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...

Generally if I want to select the names starting with c I
need to use c%
But how could I code to select the data which contains %
as a part of data.

Answer Posted / prachi

SELECT NAME FROM EMP WHERE NAME LIKE 'C%';

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain dclgen.

1200


What is iseries database?

1046


define clustering index.

1027


What is db2?

1182


What is the difference between dbm cfg and db cfg file in db2 ?

1535


What is dbrm? What it contains?

1163


How to create backup table in db2?

1090


Explain in brief how does db2 determine what lock-size to use?

1045


What is the maximum size of a char data type in db2?

1010


File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

2939


Why select is not preferred in embedded sql programs?

1299


How can you quickly find out the # of rows updated after an update statement?

1047


What is the physical storage length of time data type?

1128


List out the data types available.

1153


what is db2 restart?

2159