hi, it may be correct ans.check out this.. SELECT * FROM table

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.

Question Posted / anand

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

Please Help Members By Posting Answers For Below Questions

What types of tables are there in the db2 database?

1061

Explain about dbrm.

1051

Which are the db2 tools to protect integrity of the database?

1124

What is db2 connect?

1081

What is cursor stability in db2?

1363

What are the different types of base tables?

1100

How can you classify the locks in db2?

1093

What is a system catalog table in db2?

1191

What is the difference between cursor and select statement?

1114

What is the difference between nvl and coalesce?

1065

What is the usage of open cursor command?

1103

What is the default page size of buffer pools?

1124

Is it possible using max on a char column?

1146

How to find the number of rows in db2 tables?

1073

How do you pull up a query which was previously saved in qmf?

1155