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.
- 5 Answers
- 8122 Views
- I also Faced
- E-Mail Answers
Answer Posted / anand
hi,
it may be correct ans.check out this..
SELECT * FROM table_name WHERE column_name LIKE 'C%%'
ESCAPE'%';
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
Is db2 a mainframe?
What os does db2 run on?
What is bind and rebind in db2?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
What is sqlca’s maximum length?
what are bind concepts in db2 cobol?
Why do we use cursor?
What does sqlcabc has?
How to run db2 command in windows?
What db2 400?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
How do I connect my db2 database to ibm?
What is page size in db2?
What is the usage of open cursor command?
Explain about rct.
