SELECT * FROM file_name
WHERE Len(col_name) < 15;
strings ending in question marks
SELECT * FROM file_name
WHERE col_name Like '*[?]';
non-consecutive words
SELECT * FROM file_name
WHERE col_name LIKE 'Where *put*';
...or...
SELECT * FROM file_name
WHERE col_name LIKE 'Where*' AND col_name LIKE '*put*';
word search with string length restriction
SELECT * FROM file_name
WHERE col_name LIKE '* envie*' AND Len(col_name) < 30;
exclude words or strings
SELECT * FROM file_name
WHERE col_name LIKE '*meet*' AND col_name NOT LIKE '*nice to meet you*' AND col_name NOT LIKE '*meeting*';
strings with apostrophe (double the apostrophe to search)
SELECT * FROM file_name
WHERE col_name LIKE '*ce que*' AND col_name NOT LIKE '*Qu''est-ce que*' AND Len(col_name) < 30;
AND & OR
SELECT * FROM file_name
WHERE (col_name LIKE '*better*' OR col_name LIKE '*best*') AND Len(col_name) < 30;
strings with 'au' followed by consonants
SELECT * FROM file_name
WHERE your_column LIKE '*au[bcdfghjklmnpqrstvwxyz]*';