quote:

---

Originally posted by visakh16

Its always better to do this at front end wherever possible as its a presentation issue

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

---

quote:

---

Originally posted by madamvegas

Converting an access db to sql and there is a function called StrConv which can convert the first letter of each word to uppercase. I checked to see if there was a corresponding function in sql and didn't find one. Is there an easy way to do this?

Very new to sql so trying to get into using the easist stuff I can so I can understand what I am doing whether than just copying someone's code.

thanks

Theresa Burk

---

check this out 


declare @a varchar(20)
set @a = 'vijay'
select @a, upper(SUBSTRING(@a,1,1)) as firstc
,SUBSTRING(@a,2,len(@a))as remainig,upper(SUBSTRING(@a,1,1))+''+SUBSTRING(@a,2,len(@a))

quote:

---

Originally posted by vijays3

quote:

---

Originally posted by madamvegas

Converting an access db to sql and there is a function called StrConv which can convert the first letter of each word to uppercase. I checked to see if there was a corresponding function in sql and didn't find one. Is there an easy way to do this?

Very new to sql so trying to get into using the easist stuff I can so I can understand what I am doing whether than just copying someone's code.

thanks

Theresa Burk

---

check this out 


declare @a varchar(20)
set @a = 'vijay'
select @a, upper(SUBSTRING(@a,1,1)) as firstc
,SUBSTRING(@a,2,len(@a))as remainig,upper(SUBSTRING(@a,1,1))+''+SUBSTRING(@a,2,len(@a))

---