SELECT * UPPER(SUBSTRING(<COLUMNNAME>,1,1)) +LOWER(SUBSTRING(<COL

how to select a field with firstletter as capital and
remaining are small letters

Question Posted / priya

Answer Posted / priya

SELECT * UPPER(SUBSTRING(<COLUMNNAME>,1,1))
+LOWER(SUBSTRING(<COLUMNNAME>,2,LEN(<COLUMNNAME>))) AS
<SOMENAME> FROM <TABLENAME>

Is This Answer Correct ?

10 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is table-valued sub query?

967

Tell me what are the advantages of using stored procedures?

1014

Any one plz send me SQL Server Developer/DBA resume for 4 years experience

2752

What is collation sensitivity? Explain different types.

1010

Describe and explain about SQL native client?

1108

What is data mart? : sql server analysis services, ssas

1055

what are the critical issues you have resloved in your company

1962

Where sql server usernames and passwords are stored in a sql server?

989

what is normalization? Explain different levels of normalization? : Sql server database administration

1327

What is a table called, if it has neither cluster nor non-cluster index? What is it used for?

1029

What are the types of database recovery models?

1125

How to create stored procedures with parameters in ms sql server?

1079

Can two tables share the same primary key?

917

How can you hide the sql server instances?

1021

What is a unique index?

934