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
- 19360 Views
- I also Faced
- E-Mail Answers
Answer Posted / priya
SELECT * UPPER(SUBSTRING(<COLUMNNAME>,1,1))
+LOWER(SUBSTRING(<COLUMNNAME>,2,LEN(<COLUMNNAME>))) AS
<SOMENAME> FROM <TABLENAME>
| Is This Answer Correct ? | 10 Yes | 0 No |
Post New Answer View All Answers
how you can deploy an ssrs report?
What is transaction server auto commit?
How can we delete a table in sql server?
What is abstracting periodical?
Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?
Explain transaction server isolation?
Which tcl commands are available on the sql server?
Explain the different types of backups available in sql server? : sql server database administration
what stored procedure can you use to display the current processes? : Sql server administration
What is the difference between Triggers and Stored Procedure?
What is an sql server agent?
What is difference between join and natural join?
What are the advantages of using cte?
Explain what is sql server english query?
How do you troubleshoot errors in a SQL Server Agent Job?
