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 |
|
satyaanandandra
Starting Member
1 Post |
 Posted - 2008-07-11 : 02:41:29
|
| Hi All,I have a requirement that I have to make the initial letter of a word to capital letter and the initial letter of the month should be capital letterhow can I achieve this.. I know how to make it into upper case to the whole word butI don't know how to make the initial letter to the capital letterreply me soonRegards,Anand |
|
|
dshelton
Yak Posting Veteran
73 Posts |
Posted - 2008-07-11 : 02:57:10
|
| declare @temp varchar(10)select @temp = 'testing'select upper(left(@temp,1)) + right(@temp, len(@temp)-1) |
 |
|
|
VGuyz
Posting Yak Master
121 Posts |
Posted - 2008-07-11 : 03:44:09
|
| select upper(left('test',1))+right('test',len('test')-1) |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-07-11 : 03:53:20
|
quote:
Originally posted by VGuyz
select upper(left('test',1))+right('test',len('test')-1)
How do you think is this different from what dshelton posted? |
|
|
|
Vikranth
Starting Member
1 Post |
Posted - 2009-05-04 : 08:17:19
|
| Try this one , u will get the same result as like the above queries "select left(upper('barack obama'),1)+stuff(lower('barack obama'),1,1,'') But it's not an easy to understand unless u know about the stuff function Thank you, |
|
|
|
Arnold Fribble
Yak-finder General
1961 Posts |
Posted - 2009-05-04 : 10:25:33
|
| None of the answers so far deal correctly with Croatian title-case digraphs. |
|
|
|
|
|
|
|
|
Initial Capital letter