Hi,

I want to display the name in Title case (like this - Soura Raja)

Please advise me.

rgds,
Soura

Not sure how your underlying structure of the table is, netter you post
some DDL to find a solution for you http://www.aspfaq.cpm/5006. A
proper soltion, if you have both Firstname and LastName as a column
would be:

SELECT FirstName + ' ' + Lastname
FROM SomeTable

HTH, jens Suessmeyer.

Hmm... Are you talking about capitalizing first letters of words? Why would
you want to do this in T-SQL? This should be handled on the application tier.

Anyway, google for "proper case SQL".


ML

---
http://milambda.blogspot.com/

Order By Primary Key
Select where result are by the best match
where current of cursorName
Really really slow cursor
Problem copying data from column in same table