How to write a SQL statement pull out string data contain '%'

Hi All,

For example, one table has a varchar2(20) column, there are three rows in this table:

1        'Mon%day'
2        'Tuesday'
3        'Wedne%sday'

Anyone know how to write a SELECT statement pull out row 1 and 3 which contain '%' character?

Thanks in advance
Helen Received on Sat Dec 02 2000 - 09:30:25 CST