Use '%%' to select the data which contains %

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 / bala

Answer Posted / bala

Is This Answer Correct ?

7 Yes

5 No

Please Help Members By Posting Answers For Below Questions

How to run db2 command in windows?

1141

Is db2 a database?

914

What is a bind in db2?

985

Is it possible using max on a char column?

1086

Explain the benefits you can get from mainframe connect?

912

List down the types of triggers in the db2 database?

965

What is the difference between oracle and db2?

1033

How would you find out the total number of rows in a db2 table?

990

What is sqlca’s maximum length?

1104

How do I copy a table in db2?

953

What is universal database?

1029

What is check constraint. Explain with example.

1047

Is ibm db2 open source?

1016

What is the difference between cursor and select statement?

1056

What is the role of the data page in the db2 database?

975