Hi
standard function initcap() should do the job. May be , first you need
to do lower()
and then do initcap().
You can add two columns col1||col2
Syntax of substring is like substring($string from pos for len)
Vijay
Fredrik Thunberg wrote:
>
> Hi all.
>
> How do you add two strings in sql?
>
> I have a name field in one of my tables and all the names are in uppercase
> (like "FREDRIK").
> I want to get the names in the usual format (First letter capitalized)
> "Fredrik". How
> do I do that?
>