December 19, 2001 at 11:18 am
I need to format names, i.e., first names and last names as follows: Change First Character of first and last name to capital letter and take care of special names, such as, Mc Donald, O'Melveny, etc.
Does anyone know of a utility program or script? Please help.
Dagnea
December 19, 2001 at 11:23 am
Are these in the same column or separate? Just makes it easier if they are.
Here's some notes:
http://www.sqlservercentral.com/columnists/sjones/tamethosestringspart7.asp
Steve Jones
December 19, 2001 at 11:36 am
They are in separate fields, i.e., First name and Last name are two different fields
December 19, 2001 at 11:46 am
Even easier. look over the article. For special cases, you will need to build a case statement to handle each.
Steve Jones
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply