Upper case string to Title case conversion

Question

Upper case string to Title case conversion

spaliwal

Mr or Mrs. 500

Points: 544
More actions
October 3, 2003 at 5:27 am

#82278

Hi Experts,
Sql server 2k sp3a on Win 2k
I have to convert a string inot Title case as given below -
100 RANDOM TEST --> 100 Random Test
Any help pl.
Thanks,
Sheilesh

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

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

mromm SSCarpal Tunnel Points: 4301 More actions · Answer 1

You can do it by utilizing string functions of SQL Server including REPLACE, ASC, CHAR, etc. But the code will be... not pretty and slow. It makes sense to consider doing such translation on the front end if possible. After all, this is a presentation issue so do it in the presentation layer.

Michael

spaliwal Mr or Mrs. 500 Points: 544 More actions · Answer 2

Hi Michael,

Thanks for the reply. Actually i was looking it to update the tables existing string values - i found one which i am sharing with all , pl. see the URL -

http://www.winscriptingsolutions.com/Articles/Index.cfm?ArticleID=23124

Cheers,

Sheilesh

Jonathan SSC-Insane Points: 20427 More actions · Answer 3

If all values do not require converting, I suggest you use the UDF with a WHERE clause like this:



UPDATE MyTable

SET MyCharCol = dbo.udf_Proper(MyCharCol)

WHERE CAST(MyCharCol AS varbinary(8000)) <> CAST(dbo.udf_Proper(MyCharCol) AS varbinary(8000))

This can be faster as it will prevent unnecessary updating and logging.

--Jonathan

mrgaurav_gupta SSC Rookie Points: 46 More actions · Answer 4

Hi,

Well I did the same in my database.

If u want to perform this on every insert then it will be very tedious as it will require a lots of processing. If u want to perform the action on already inserted values then try using a cursor and String functions.

Mail me at gauravgupta@adventmatrixinc.com for the code.

.........