how to select a field with firstletter as capital and
remaining are small letters
- 11 Answers
- 17339 Views
- I also Faced
- E-Mail Answers
Answer Posted / radhika
SELECT Left(upper(<field_name>) , 1) + substring(lower
(<field_name>, 2, len
(<field_name>))
FROM <table_name>
| Is This Answer Correct ? | 6 Yes | 4 No |
Post New Answer View All Answers
Do you know the different ddl commands in sql?
What is the definition for sql server 2000?
how many layers of tcp/ip protocol combined of? : Sql server database administration
Explain the use of containers in ssis?
Explain how to send email from sql database?
How data can be copied from one table to another table?
What is use of except clause? How does it differ from not in clause?
How to concatenate two character strings together?
What are the steps you can take to avoid “deadlocks”?
Where sql server usernames and passwords are stored in a sql server?
Can we add an identity column to decimal datatype?
What is difference between getdate and sysdatetime in sql server 2008?
where can you add custom error messages to sql server? : Sql server administration
What are types of subqueries?
What is the stuff and how does it differ from the replace function?
