Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

Answer Posted / venakteswara rao

select upper(<colummn name>,1,1)+substring(lower(<column
name,2,len(<column name>))) as anyname from table name

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain about local stored procedure?

942


What is the most common trace flags used with sql server?

1026


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

999


What are the basic functions for master, msdb, model, tempdb and resource databases?

971


Why does sql studio use a single registered database repository? : sql server management studio

982


Explain the types of indexes.

1182


Using the customer, and order table in northwind database, please write a query to produce xml?

1053


Describe in brief sql server monitoring ways.

1035


What are partitioned views?

966


What is transactional replication?

944


What is policy management?

977


What is the difference function and stored procedure?

1033


What is an identity?

982


What the class forname () does?

1034


can we have a nested transaction? : Sql server database administration

1055