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
Why select is not preferred in embedded sql programs?
What are the 2 sqlcodes that are returned?
What is multi row fetch in db2?
What is the use of runstats in db2?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
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?
What is the role of schema in the db2 database?
What is check constraint in db2?
Highlight all the advantages that are attached to a package.
How many databases are there?
What is cursor with hold option in db2?
What is a page in db2?
Is db2 a mainframe database?
What is node in db2?
What is load utility in db2?