I think the problem was that for AND to kick in, it was looking for two spaces rather than one. It seemed ok when I got rid of the extra %20.
The next question is - if I search for "deco", the results bring up matches with the word deco and also decorative
How can I get the query to come out like this:
WHERE ((stockDesc LIKE 'deco') OR (stockNo LIKE 'deco') OR (fullDesc LIKE 'deco'))
WHERE ((stockDesc LIKE '%deco%') OR (stockNo LIKE '%deco%') OR (fullDesc LIKE '%deco%'))