INITCAP option in memsql

HI Team
Do we have INITCAP function in memesql i have not seen any commend in the document.
please let me know is there any fucntion?

Hi,

No we don’t support such a builtin function today. You’ll have to write a UDF to do it. Something similar to: https://stackoverflow.com/questions/12364086/how-can-i-achieve-initcap-functionality-in-mysql (converted over to SingleStore syntax for UDFs).

I’ve also files a feature request for this builtin internally.

-Adam

Actually, the issue here is missing documentation. We do actually support this Oracle builtin function:

MemSQL [(none)]> select initcap("this is a title");
+----------------------------+
| initcap("this is a title") |
+----------------------------+
| This Is A Title            |
+----------------------------+

I’ve filed a request to update the documentation

1 Like