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 what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

886

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

1085

Explain about Joins?

969

What stored by the tempdb ? : sql server database administration

1030

How to find index size for each index on table?

990

What are relationships and mention different types of relationships in the dbms

946

Are connections to sql server encrypted?

987

Tell me the difference between clustered and non-clustered index?

922

Explain the various types of concurrency problem?

1164

Explain powershell included in sql server 2008?

1039

What are the advantages of using a stored procedure?

991

What is nonclustered index with included columns ?

946

How to add an address record into adventureworkslt?

971

What is create statement?

928

Difference between DELETE and TRUNCATE?

1034