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
- 19379 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
What will be query used to get the list of triggers in a database?
When I delete any data from a table, does the sql server reduce the size of that table?
Explain the third normal form(3nf)?
How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?
Why we need sql server?
What is report rendering ?
How do I shrink an ldf file?
which backup strategy you are following at ur company
How to list all user defined functions in the current database?
What is the bookmark lookup and rid lookup?
What is the maximum length of an alert name?
How you can find out if an index is useful to the optimizer?
State the difference between local and global temporary tables?
What is inline table-value user-defined function?
What is the need for group functions in sql?
