Search % in Database

[andigwandi]

Can anyone tell me how i can search for '%' character in database

like

Select * from Table where Field like '%'

The Field will contain % as value in it.

And I need all the rows having field value started with '%'

Thanks in Advance

[Paritrana]

This may help you try it---
SELECT COL1 FROM TABLE_A WHERE
COL1 LIKE '% [%] %' OR

SELECT columns FROM table WHERE column LIKE '%\%%' ESCAPE '\'