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 is the use of reorg in db2?

1024

Who uses db2?

981

can all users have the privilage to use the sql statement select * (dml)?

1103

What is the role of schema in the db2 database?

1182

What do you mean by cursor?

942

What is collection in db2 bind?

961

What type of database is db2?

911

What is rebind in db2?

999

What is host variable?

1012

What is universal database?

1029

How to execute stored procedure in db2 command editor?

984

B37 abend during spufi?

1405

Explain package in db2 and its advantages?

1134

Mention the downsides of page level lock.

1112

What is the use of predicate?

983