I run www.sateuropa.co.uk
, and I'm having trouble modifying our search feature, it's showing results, but only if the input is exactly as written and the first part of the field.
EG if you search 6900 it gives NO RESULTS, if you search the model's exact name TM-6900 it shows the results. I'd like it so that 6900 does show the TM-6900 as this is part of the product name.
Would anyone kindly be able to advise how I need to modify this below to action this?
I'll be so very grateful! Simon, Southampton, UK
if txtType = 1 then 'manufacturer
txtSQL = "SELECT * FROM products where manufacturer LIKE '" & txtSearchText & "%' OR Name LIKE '" & txtSearchText & "%'"