I will like to change the format of text values in a column to camel case in Sybase For example NEW YORK should be New York
Asked
Active
Viewed 414 times
1
-
which Sybase product (ASE? SQLAnywhere? IQ? Advantage?), and what have you tried so far? – markp-fuso Apr 24 '18 at 16:30
-
Sybase IQ. I am new to Sybase and the unique text functions I have encountered so far are UPPER and LOWER. – Diddy Apr 24 '18 at 16:36
-
I don't think IQ (or SQLAnywhere, which IQ uses as a front end) have anything like Oracle's `initcap()` so you'll likely need to write your own; a quick search brings up multiple hits, like [this](https://stackoverflow.com/q/55054/7366100) and [this](https://stackoverflow.com/q/5164201/7366100) – markp-fuso Apr 24 '18 at 16:51