Proper Casing varchar fields

[delaap]

Hi,

I'm trying to write some code that will change text from UPPER case into PROPER case i.e.

From: BANK OF SCOTLAND
To: Bank of Scotland

I remember using a PROPER function in foxpro a few years ago and I'm basically trying to replicate this.
Any ideas ?

 

[aalmeida]

I would suggest you to start reading BOL on "String Functions" T-SQL it will give you an ideia of what to do since the "proper" function is not available you'll need to play with you Strings to get it to the proper case. AL Almeida
NT/DB Admin
"May all those that come behind us, find us faithfull"

 

[tlbroadbent]

Here is a link to a Proper Case procedure in the SQL FAQ.

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

And a link to another proc on SWYNK.COM.

http://www.swynk.com/downloads/TitleCase.sql

Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.