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.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  Anything Like InitCap in SQL

Author  Topic  keyur Starting Member 4 Posts Posted - 2001-11-03 : 05:11:11 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 ried BOL butno luck there , infact in string comparision it is blank in front of initcap Any suggestions will be welcome TIA, keyur