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
What is the difference between mysql and mysqli?
How sql server executes a statement with nested subqueries?
Mention the differences between substr and charindex in sql server.
How to declare and use cursor variables?
Are there issues when exporting SSRS reports into Microsoft Excel? When my users are trying to export a SSRS report into Microsoft Excel, one or two columns in the report appear to merge together. Why might this be?
explain different types of joins? : Sql server database administration
What is an example of a primary key?
What is the difference between coalesce() & isnull()?
How to resolve the orphan use problem? : sql server security
Explain the properties of the relational tables?
How can I create a report based on a query? : sql server management studio
What is wrong with sql server client libarary dll, ntwdblib.dll?
if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration
How to list all schemas in a database?
What samples and sample databases are provided by microsoft?