Hi Ruslan Can you give me any advice on how to convert a search term into a valid SQL statement. The search field may have: camera and lens (AND search) camera or lens (OR search) "camera lenses" (phrase search) "camera lens*" (wildcard + phrase) ... And any combination of the above. Martin