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
- 18905 Views
- I also Faced
- E-Mail Answers
Answer Posted / vidit tyagi
SELECT Left(upper(<field_name>) , 1) + lower(substring
(<field_name>,2,len(<field_name>))) AS SomeName
FROM <table_name>
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is the difference between rank and dense_rank?
What is query cost in sql server?
Do you know what are the ways available in sql server to execute sql statements?
Which trace flags are enabled in sql server?
Define Business Edition in SQL Azure?
What are points to remember while using the fillfactor argument?
What are the extra roles available in msdb? : sql server security
What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?
What is the difference between varchar and varchar types?
What are cursors and when they are useful?
How many types of stored procedures are there in sql server?
What is a trigger? Why we need it?
What are different types of database indexes?
Explain subquery and state its properties?
What is sql injection? How to protect against sql injection attack?
