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?


No we don’t support such a builtin function today. You’ll have to write a UDF to do it. Something similar to: (converted over to SingleStore syntax for UDFs).

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


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