Re: Update value to "the first character is capital and

[John Sidney-Woollett <johnsw@xxxxxxxxxxxxx>]

Have you tried the initcap function?

 select initcap('abcd efgh');
  initcap
-----------
 Abcd Efgh

John


Emi Lu wrote:
> Hello all,
>
> Does anyone have available plpgsql codes to update all capital letters 
> in a column to "the first character is capital and the rest is small" ?
>
> For example, in tableA(id, description)
> 001,  'ZHANG ZHE XIN'                                              =>    
> 'Zhang Zhe Xin'
> 002,  'LIU, WEI-HUAI'                                                  
> =>    'Liu, Wei-Huai'
> 003,  'GU & WEI. NAN (CE SHI) & TOMMORROW'      =>   'Gu & Wei. Nan (Ce 
> Shi) & Tommorrow'
>
> Thanks a lot!
> Ying
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings