Need help with column update

[sfierce]

Some of the last names that we have in a last_name column of a user table are hyphenated names, i.e. Green-thumb. I'm looking for a way to update the last_name column so that not only the first character of the field is Upper case, but the character following the hyphen is forced to be Upper case as well. If anyone can help with the syntax to do this it would be greatly appreciated.

Thank you,
sfierce

 

[pmanivas]

Do u want to do this format at the backend or at the front end

 

[tlbroadbent]

If you have SQL 2000, you can use a UDF. Narayana Vyas Kondreddi provides code for such a UDF at his website.

http://vyaskn.tripod.com/code/propercase.txt

If you have an earlier version, check Neil Pike's FAQ on Proper Case at

http://www.windows2000faq.com/Articles/Index.cfm?ArticleID=14117

You may need to modify these routines slightly to meet you exact needs. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.