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

[John Sidney-Woollett]

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

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly