conversions to proper case

Question

conversions to proper case

Viewing 3 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

sushila SSC-Dedicated Points: 35293 More actions · Answer 1

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 !!!**

DSP-120308 Hall of Fame Points: 3959 More actions · Answer 2

Shouldn't this be done client side (I know that VB has a vbProper function that would handle it)?

ron k SSCertifiable Points: 6103 More actions · Answer 3

Take a look at this thread for some ideas:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=23&messageid=111988