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
- 6936 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / mdvasanth86
Anand is right.
SELECT * FROM table_name WHERE column_name LIKE 'C!%'
ESCAPE'!';
If you want to use % or _ as part of your like clause,
you must have an escape character before each occurrence of
% or _ and define what the escape character is like above.
So, an escape character before the % or _ will make it part
of the string rather than a wildcard character(S).
HTH
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / guest
C% will work for all the cases. Even if the data contains
%, Using C% will fetch that too.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / 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 |
What is the difference between TYPE 1 index & TYPE 2 index
What is the maximum size of varchar data type in db2?
What is a db2 table?
What is check constraint in db2?
Explain dclgen.
Explain about dbrm.
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
How do you simulate the EXPLAIN of an embedded SQL statement in SPUFI/QMF? Give an example with a host variable in WHERE clause)
How to see the structure of db2 table??
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
What is the maximum length of sqlca?
the dd name for ksds is dest1 and what is the dd name for alternate index of ksds ? a.dest b.dest1 c.dest1a d.dd1
COBOL 
