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 does db2 blu stand for?

1154

Is the primary key a clustered index?

1136

What is coalesce in db2?

1122

How do you find the maximum value in a column in db2?

1093

What are the full forms of spufi and dclgen and why are they used?

1080

Can we update view in db2?

990

What is the function of logging in the db2 database?

1109

What is the maximum size of varchar data type in db2?

1120

What is blu acceleration in db2?

1060

Is schema the same as database?

1050

What are the various data types available in db2?

1080

What are host variables in db2?

1043

What is load replace in db2?

986

What is the physical storage length of date data type?

1244

What are the different types of base tables?

1082