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

What is attribute hierarchy? : sql server analysis services, ssas

713


What is a trigger in sql server?

760


Why functions are used in sql server?

669


How dts is used to extract, transform and consolidate data?

789


Explain sql delete command?

792






what is checksum in sql server.........???

1376


How do I find the sql server version?

711


Explain what are commit and rollback in sql?

677


How do I view a procedure in sql server?

750


What is query and its types?

687


Explain query editor regions

798


Difference between 2NF &3NF ?

843


Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication

780


Can foreign key be deleted?

679


What is the report builder?

121