SELECT Left(upper(<field_name>) , 1) + substring(lower (<field

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

Question Posted / radhika

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

Please Help Members By Posting Answers For Below Questions

Explain about nested stored procedure?

1030

How to get all stored procedures in sql server?

1001

Does view occupy space?

945

What is ddl and dml commands?

905

How secure is sql server database?

1009

Define the one-to-one relationship while designing tables.

903

Does index speed up select statements?

1012

How to use go command in "sqlcmd"?

1205

A trigger can reference objects outside the current database? State true or false.

1008

What is BCP? When does it used in sql server 2012?

1062

What is a filestream?

991

What is delete query?

940

How many types of the database links?

1070

What is difference between group by and having?

943

How to name query output columns in ms sql server?

968