I have a char field called Ads in my table... the field contains the sort of Ads that are placed on pages. The field will either have one or a combination of the following:

- None
- Frame
- Delay
- Banner
- Pop-up

I know ow you handle a SELECT statement if searching for records with None in the Ads field, but if one record had the following in the Ads field: "Frame Delay" meaning that either a Frame of Delay ad is used, how would I be able to search for "Frame" and still be able to pull records that contained "Frame Delay" from the table? What, if possible, would the SQL statement look like?