I'm looking for an equivalent method of the Oracle NLS_INITCAP, that returns a charaters in lower case but the first letter of all words that are in capital.
I just went through the standard functions without finding a equivalent to the ORACLE function you mentioned.
You could create your own using UCASE, LCASE, LENGTH and SUBSTR functions such as:
or something along the line , for variable length strings.
Must be a simpler solution one should think..... T. Blom
Information analyst
tbl@shimano-eu.com
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.