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 |
|
subhaoviya
Posting Yak Master
135 Posts |
 Posted - 2012-07-16 : 09:57:51
|
| To make the field values in upper case like 'VALUES' we can use UPPERCASE(ColumnName) function, to make the field values in lower case like 'values' we can use LOWERCASE(ColumnName). is there any function to get the values in InitialCapital value like 'Values'.Thanks Subha |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2012-07-16 : 09:59:48
|
| something likeselect stuff(lower(ColumnName),1,1,upper(left(ColumnName,1)))==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-07-16 : 10:01:12
|
| I would have done it at front end if possible, as this is basically a presentation requirement------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
subhaoviya
Posting Yak Master
135 Posts |
Posted - 2012-07-16 : 10:26:29
|
| thanks. its working fine |
|
|
|
|
|
|
Initial casing for field values