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
- 8112 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 role of data manager in the db2 database?
define clustering index.
What is the COBOL picture clause for a DB2 column defined as DECIMAL(11,2)?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
Explain about rct.
how can u retrieve the data from null values using applicaion program.
How can we define a table? How can we apply SEARCH ALL on it ?
What is a cursor in programming?
Mention data types used in db2 ?
select 100 records from million records ?
Which catalog table stores referential constraints?
What is FREEPAGE and PCTFREE in TABLESPACE creation?
COBOL 
