Hi Ray,
I understand what you are saying but let us say that I am searching for products from a particular supplier then the results are not found, for example 'Pioneer ribbon' I can search individually for these terms, either the supplier 'Pioneer' or something that would be found in the product description 'Ribbon' and that is why I though about using CONCAT() in the recordset. Is it possible to do get results for products from a particular supplier using search; I am fairly sure I had this running like this using DataAssist when my site was coded in ASP.
Kind regards.