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 / 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
Define predicate?
How can we read records for specific member in CL? AND rpg?
What is dbrm in db2 database?
What does db2 mean?
What are host variables in db2?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
what is the responsibility of the construction superintendent
How can you do the explain of a dynamic sql statement?
What is innodb buffer pool?
How to check last update on table in db2?
What is the maximum length of sqlca?
What is bufferpool in db2?
How to create backup table in db2?
How to rename a table in DB2 ?
How do I change the column size in db2?