Select UPper(Left(Company,1)) + Lower(Right(Company,Len (Company)-1)) From

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

Question Posted / velmurugan

Answer Posted / velmurugan

Select UPper(Left(Company,1)) + Lower(Right(Company,Len
(Company)-1)) From Company

Is This Answer Correct ?

2 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How to delete duplicate rows in sql server?

1058

What is the definition for sql server 2000?

1043

What is the maximum size per database for sql server express?

975

Mention the uses of stored procedures.

928

Explain the steps needed to create a scheduled job?

886

What is difference between clustered index and non clustered index?

1030

What is a field name?

915

What is difference between group by and having?

911

What are indexes in ms sql server?

1000

What happens on checkpoint?

970

What is meant by Active-Passive and Active-Active clustering setup?

1069

What is acid db?

841

How to create a dml trigger using create trigger statements?

977

Explain datetime2 data type in sal server 2008?

857

What are the tools available in market as an alternative to sql server reporting services?

119