Interested to Buy Any Domain ? << Click Here >> for more details...
how to select a field with firstletter as capital and
remaining are small letters
- 11 Answers
- 18920 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
What is schemabinding a view?
What are the different types of cursor?
How do you create a clustered index?
What are the filtered indexes?
1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?
According to you what goes into making the best database administrator? : sql server database administration
How to search for a string in all stored procedure in sql server?
What happens if null values are involved in comparison operations?
but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration
Explain what is log shipping?
How do you delete duplicate records in sql server?
What are the security related catalog views? : sql server security
What is log in sql server?
How to rename an existing column with sql server management studio?
What is default constraint?
