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

Answer Posted / velmurugan

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

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you create a data source?

581


What is a trace frag? Where do we use it?

745


How can I create a new template for import ? : sql server management studio

686


What is reportserver and reportservertempdb ?

116


List out the differences between global and local temp tables in sql server?

661






What are locks in sql?

618


Can primary key be a foreign key?

655


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

634


what are different types of raid configurations? : Sql server database administration

593


How to delete existing rows in a table?

673


What do you mean by authentication modes in sql server?

697


What is rank function?

684


What are Row versions of DataRow?

697


How to create new databases with "create database" statements?

655


Why do you want to join software field as you have done your BE in Electronics?

1786