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 Rdbms?

1132

What sql server means?

951

Explain what are magic tables in sql server?

978

What do you mean by an execution plan? How would you view it?

904

What is sql server english query?

1103

How to execute stored procedure and set temp table in sql server?

1023

What is the use of nvl work?

987

how can u get last observation in an unknown dataset ?

2422

Which is the latest version of sql server and when it is released?

1089

What is cached report?

143

Can you type more than one query in the query editor screen at the same time?

989

How to use transact-sql statements to access the database engine?

1042

What is deploy, process and build? : sql server analysis services, ssas

1085

What are the commands used in DCL?

1006

Explain sql server service broker?

957