how to select a field with firstletter as capital and
remaining are small letters
- 11 Answers
- 17408 Views
- I also Faced
- E-Mail Answers
Answer Posted / dharmendra k dixit
Select Left(Upper((YourColumnName), 1) + Substring(Lower
(YourColumnName),2,Len(YourColumnName))AS UName
From YourTableName
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
How to grant a permission in ms sql server using "grant execute" statements?
What is the new security features added in sql server 2016? : sql server security
How will you make an attribute not process? : sql server analysis services, ssas
Explain can you implement data mining in ssrs?
What does select 1 mean?
How fixed length strings are truncated and padded?
How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?
Tell me can we use custom code in ssrs?
Explain the difference between cross join and full outer join?
Write the SQL query to drop, truncate and delete table.
What is a periodical index?
What are key, name and value columns of an attribute? : sql server analysis services, ssas
How do you create an execution plan?
What are the system database in sql server 2005?
Explain index in sql server?
