INITCAP option in memsql

Help Procedural SQL
1

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?

2

Hi,

No we don’t support such a builtin function today. You’ll have to write a UDF to do it. Something similar to: How can I achieve initcap functionality in MySQL? - Stack Overflow (converted over to SingleStore syntax for UDFs).

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

-Adam

3

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