Searching for percent character (%) in a string
626975Mar 19 2008 — edited Mar 19 2008Hi All,
A strange request from one of our developers that I have not come across before.
Is there a way to search for a percent character (%) in a string and also use the wildcard special character (%)?
i.e. to return all values with a percent character (%)
e.g. select column1 from table1 where column1 like '%%';
When I do this all records are returned.
Regards!!