Well I had a similar problem.. Try this one (!not a search!): [sql type="list" query="select code from products where name like %[value textfield]% or Description like %[value textfield]% or Description2 like %[value textfield]% and shop = 1"]
