select upper(<colummn name>,1,1)+substring(lower(<column name,2,l

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

Question Posted / venakteswara rao

Answer Posted / venakteswara rao

select upper(<colummn name>,1,1)+substring(lower(<column
name,2,len(<column name>))) as anyname from table name

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is provisioning, billing and metering, and connection routing concepts in the service layer?

113

Can you explain what are the restrictions applicable while creating views? : SQL Server Architecture

853

What are the five characteristics of good data?

870

How to create an inline table-valued function?

909

Which tcl commands are available on the sql server?

1018

Define right outer join?

933

What is the difference between a view and a stored procedure?

985

What is the full form of dql?

930

What is acid mean in sql server?

1041

What is rs.exe utility?

150

Define indexes?

999

Explain indexes disadvantages?

1011

what is a sub-report?

132

What are different types of subquery?

1182

Create and insert into temp table in sql server?

978