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
- 7796 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
Explain in detail about buffer manager and its functionalities?
Define sqlca.
What is declare cursor?
How do I delete a table in database?
How do I delete a table 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.
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
What is lock escalation in db2?
What happens in bind step in a db2 program?
What is cursor with hold option in db2?
What is the physical storage length of date data type?
What are union and union all?
What do you mean by rollback?
Explain about mirror activator disk mirroring?
What is isolation level in db2?
