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 |
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
 Posted - 2005-05-11 : 07:03:23
|
I can't find an SQL equivalent of the vba - StrConv(sTemp1, vbProperCase) which will convert my string to 'proper' case (first letter of each word capitalized and the rest lower case).Is there one or do I have to write my own?thankssteveA sarcasm detector, what a great idea. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-05-11 : 07:13:03
|
| Yep, you'll have to write your own, but creating a UDF in SQL Server to do this should be pretty simple. |
 |
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2005-05-12 : 14:30:06
|
| fair enough, thanks RobA sarcasm detector, what a great idea. |
|
|
|
|
|
|
Case load