Avatar of dsk1234
dsk1234

asked on 

Upper case to Pascal case in sql server

I have a requirement to change existing all state names (with capital letters ie NEW YORK)

to pascal cases  (first letter capitalized in each word ie New York).

How can I achieve this using sql server 2005
Microsoft SQL Server 2005

Avatar of undefined
Last Comment
dsk1234

8/22/2022 - Mon