I need to search a field that is built for searching as 'Keywords'. In this field is text and numeric with commas and dashes and spaces. I want to obviously search keywords from this field for a search page. I have tried so many variations of this syntax its unreal. I can't make it work using *, % or even _. It doesn't work on any field I've tried it on using a VarWChar fomat where the field has a mix of numeric and alpha.

SELECT PB.Keywords, PB.ProductBlockLabel
FROM PB
WHERE "PB.Keywords LIKE '%?%'"

Any help would be greatly appreciated. I'm pulling from an Access DB using MMX.

"Chance favors the prepared mind"

<font face='Arial'>Try rewriting your sql statement as:

SELECT PB.Keywords, PB.ProductBlockLabel FROM PB WHERE PB.Keywords LIKE "%"

If you have an older version of Access then use * in place of %</font id='Arial'>

Lafinboy Productions
www.lafinboy.com
website development :: website design :: graphic design