Probably me being thick but...

This is from a search results recordset - it works fine for the "code" and first model parts but the isModel bit is acting like = not LIKE ie if there is a field called "one two three" a search for "one" gives no results but a search in the same field for "one two three" gives the expected result

Help?

SELECT *
FROM InkStock
WHERE model LIKE '%MMColParam%' OR model LIKE 'isModel' OR code LIKE 'isCode'

Dear Husky,

SELECT *
FROM InkStock
WHERE model LIKE '%MMColParam%' OR model LIKE '%isModel%' OR code LIKE '%isCode%'

Regards,
Brent

doesn't seem to work at all now!<img src=../images/dmxzone/forum/icon_smile_sad.gif border=0 align=middle>

Try this:

SELECT *
FROM InkStock
WHERE model LIKE '%MMColParam%' AND model LIKE '%isModel%' AND code LIKE '%isCode%'

-- julio

------------------------
Julio

PHP | MySQL | DWMX | ColdFusion

ICQ: 19735247