Is it possible to string together multiple SQL LIKE wildcards in one query - something like this?
LIKE '% aaaa %' AND LIKE '% bbbb %'
The aim is to find records that contain both wild cards but in no specific order.
See Question&Answers more detail:os