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

What is collation sensitivity? Explain different types.

1020

What is an indexed view?

973

Which are the third-party tools used in sql server and why would you use them?

922

What are the Advantages of using CTE in sql server?

1130

How to connect to a sql server using odbc_connect()?

1165

How to delete a database in ms sql server?

1246

What are the advantages dts has over bcp?

1013

What happens to a trigger with multiple affected rows?

961

How do I trace a query in sql server?

966

What is meant by datasource?

935

What Are the Main Features of SQL Azure?

117

What is partition in sql server?

1048

Mention a few common trace flags used with sql server?

942

How to provide column names in insert statements in ms sql server?

1170

How to make remote connection in database?

1015