November 3, 2001 at 3:26 am
hello everybody,
a small problem again i have a table which have about 30,000 recs which are all in upper case now i need only the first letter capital rest small i.e. somthing like InitCap in orcale .. do we have any facility similar to initcap in sql.. have tried BOL butno luck there , infact in string comparision it is blank in front of initcap
Any suggestions will be welcome
TIA,
keyur
November 3, 2001 at 5:33 am
Nope. You could use upper, lower, and substring to accomplish the same thing. You'd have to put it inline in 6.5/7.0, but in SQL2K you could create a function called InitCap that would use the above to make it work the way you want.
Andy
November 5, 2001 at 2:24 am
I guess this might be useful for you.
http://www.sqlservercentral.com/columnists/sjones/tamethosestringspart7.asp
November 5, 2001 at 12:00 pm
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply