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

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

Question Posted / vidit tyagi

Answer Posted / vidit tyagi

SELECT Left(upper(<field_name>) , 1) + lower(substring
(<field_name>,2,len(<field_name>))) AS SomeName
FROM <table_name>

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is your recommendation for a query running very slow? : sql server database administration

1011

What is set nocount on?

906

Detail about query optimizer?

1050

What is raid and what are different types of raid levels?

1102

Can multiple columns be used in sql group by clause in ms sql server?

1007

what are user defined datatypes and when you should go for them? : Sql server database administration

978

What is sql server query analyzer?

985

How can we rewrite sub-queries into simple select statements or with joins?

941

What is the difference between Normalization and De-normalization?

1044

What are the common performance issues in sql server?

884

Explain transaction server explicit transaction?

895

What is a non equi join?

930

What is the Main Difference between ACCESS and SQL SERVER?

1083

How do you delete duplicate records in sql server?

1014

Does a server store data?

880