Looking for fields that contain % or _

I am trying to put a like in my where clause so that I can return records that have an _ in a specified field. Because _'s and %'s are special characters to the like I don't know how to override.

I've tried %% or __. I've also tried set escape on and using \%. niether works. Any help would be greatly appreciated.

        John Fico Received on Sat Mar 22 1997 - 00:00:00 CST