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 list all stored procedures in the current database using ms sql server?

1111

How to disable stored procedure sql server?

1588

What does sql server mean?

1035

what are the different types of replication you can set up in sql server? : Sql server database administration

1010

How to enable tcp/ip protocol on a sql server?

1143

how to create a scrollable cursor with the scroll option? : Sql server database administration

1065

Does the order of columns in update statements matter?

906

What is the definition for sql server 2000?

1075

Is sql server a database?

959

How do I manually uninstall an instance of sql server 2016?

1009

What is 5nf in normalization form?

977

What is replace and stuff function in sql server?

1051

When to use Inner join & when to use subquery?

1139

can a database be shrunk to 0 bytes, if not, why? : Sql server administration

1177

How many levels of sp nesting is possible?

1038