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
Explain about local stored procedure?
What is the most common trace flags used with sql server?
How to create new databases with "create database" statements?
What are the basic functions for master, msdb, model, tempdb and resource databases?
Why does sql studio use a single registered database repository? : sql server management studio
Explain the types of indexes.
Using the customer, and order table in northwind database, please write a query to produce xml?
Describe in brief sql server monitoring ways.
What are partitioned views?
What is transactional replication?
What is policy management?
What is the difference function and stored procedure?
What is an identity?
What the class forname () does?
can we have a nested transaction? : Sql server database administration