Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
limsy
Starting Member
3 Posts |
 Posted - 2006-10-04 : 05:47:44
|
| Hi ppl, I know there is UPPER and LOWER... but if i wanted to convert a particular field into Normal Caps... is there a simple way in SQL to do it?Thank you for your time. |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-10-04 : 05:50:57
|
| You mean starting with a upper case and the rest lower case for each word delimited by spaces?If that's all you want then it's pretty simple to write but there's no function for it.If you have anything more complicated though you might want to look at the clr and use the .net function for it.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-10-04 : 05:57:16
|
| I think our friend IGOR made a function for this here at SQLTeam.Peter LarssonHelsingborg, Sweden |
|
|
|
limsy
Starting Member
3 Posts |
Posted - 2006-10-04 : 06:18:11
|
| I tried to search for all post by IGOR, but i cant find it. Anyone any idea what keyword to search for it?clr ... *glup* I havent looked into it yet. It sure sounds cool. bcos as a programmer.. i keep forgetting to save my SQL statements before closing Query Analyzer.. hehehe...Thanks for your time guys. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-10-04 : 07:16:25
|
| http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=47718Peter LarssonHelsingborg, Sweden |
|
|
|
limsy
Starting Member
3 Posts |
Posted - 2006-10-04 : 21:23:29
|
| THANK YOU THANK YOU THANK YOU!!!!!*skips around happily*(I was already MANUALLY retyping data in our databases bcos of user complaints on the CAPS) |
|
|
|
|
|
|
Normal caps in SQL?