how to select a field with firstletter as capital and
remaining are small letters
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
Describe triggers features and limitations?
Explain the disadvantages/limitation of the cursor?
Explain the working of sql privileges?
What is inline table-value user-defined function?
Write a sql query to sort on different column name according to the parameters passed in the function?
What is RAID? What are the different types of RAID configurations?
How to start sql server browser service?
What is molap and its advantage? : sql server analysis services, ssas
What is trigger in salesforce?
What is a View ? Can we insert, Update and delete a view?
How to define and use table alias names in ms sql server?
What is server-level principal?
What is trace flag in sql server?
What are the hotfixes and patches in sql server?
Do comments need to go in a special place in sql server 2005?