Re: Concatenating strings

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?
>