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)
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?
In response to
pgsql-novice by date
|Next:||From: Chr. Rossmanith||Date: 2001-10-23 12:13:23|
|Subject: Re: Problem with createdb & case (7.1.3)|
|Previous:||From: Fredrik Thunberg||Date: 2001-10-23 09:10:57|
|Subject: Concatenating strings|