how to select a field with firstletter as capital and
remaining are small letters
Answer Posted / venakteswara rao
select upper(<colummn name>,1,1)+substring(lower(<column
name,2,len(<column name>))) as anyname from table name
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How you can find out if an index is useful to the optimizer?
What are data driven subscriptions?
What is table level trigger?
What method is used by the Command classes to execute SQL statements that return single values?
What is the difference between having clause and where clause in sql server?
What are the steps you should follow to start sql server in single-user mode?
What is entity data services?
what are acid properties? : Sql server database administration
What is bcp? When does it use?
Can sql servers link to other servers?
Why are sql functions used?
What is equi join with example?
List layers of abstraction microsoft architectured to provide relational db through cloud platform ?
what are the three command line utilities and what are their primary functions?
How to find the login name linked to a given user name?