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

How can you check the version of sql server?

1050

Explain the various types of concurrency problem?

1139

How can we determine what objects a user-defined function depends upon?

953

what are the basic functions for master, msdb, model, tempdb and resource system databases? : sql server database administration

950

Mention the command used to rename the database.

948

What is clustered vs nonclustered index?

887

What is history table in sql server?

896

How many types of triggers in sql server?

972

What are the built in functions in sql server?

919

How to convert numeric expression data types by assignment operations?

1004

Explain Normalization and DE normalization

1055

What is difference between Datepart() and Datename() in SqlServer?

1158

How to delete an existing row with delete statements in ms sql server?

1023

What are system databases into sql server (2005/2008)?

956

How to create a login account in ms sql server to access the database engine using "create login" statements?

1064