I have a field named: Title,now I want to filter the data with a specific match.
In Excel when you set the whole sheet1 to data>filter>autofilter, excel offers an Custom AutoFilter window
where you can select various condition. I noticed that one of the choices is the does not contain option
I was wondering is this possible to use in sql, aside from LIKE and BETWEEN bec. I'm dealing with long titles and
would like to include the condition:
Expand|Select|Wrap|Line Numbers
- SELECT *
- FROM Table1
- WHERE Table1.Title does not contain = jkl