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 tcl in sql server?

681


What is bcp? When does it used?

557


How to create a view with data from multiple tables?

567


What area unit the various kinds of info compression introduced in sql server 2008?

576


What is usually the first word in a sql query?

607






How do I connect to sql server database?

490


Can select statements be used on views in ms sql server?

597


How to generate create table script on an existing table in ms sql server?

655


Explain what is analysis service repository?

548


What is openrowset sql server?

530


How to write an inner join with the where clause in ms sql server?

563


Does a full backup include transaction log?

487


What are some of the pros and cons of not dropping the sql server builtinadministrators group? : sql server security

556


Why use “pivot” in sql server?

629


Explain indexed views?

566