June 24, 2005 at 11:22 am
I have a database that contains a description field that happens to be in all caps ... I need to convert that to proper case. What is the easiest solution for this?
"The grass is always greener over the septic tank." ~Leaf
June 24, 2005 at 11:49 am
There are any number of ways to do this but you would basically be using LOWER() for the field in all but the first character - and if you have phrases, sentences etc.. then the manipulation would probably need you to loop through the field looking for spaces etc.....
**ASCII stupid question, get a stupid ANSI !!!**
June 24, 2005 at 12:14 pm
Shouldn't this be done client side (I know that VB has a vbProper function that would handle it)?
June 24, 2005 at 1:45 pm
Take a look at this thread for some ideas:
http://qa.sqlservercentral.com/forums/shwmessage.aspx?forumid=23&messageid=111988
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply