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 / bala

Use '%%' to select the data which contains %

Is This Answer Correct ?    7 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why select is not preferred in embedded sql programs?

711


What are the 2 sqlcodes that are returned?

639


What is multi row fetch in db2?

601


What is the use of runstats in db2?

577


What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

708






I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

1938


What is the role of schema in the db2 database?

649


What is check constraint in db2?

603


Highlight all the advantages that are attached to a package.

627


How many databases are there?

590


What is cursor with hold option in db2?

612


What is a page in db2?

610


Is db2 a mainframe database?

567


What is node in db2?

608


What is load utility in db2?

665