I'm not sure why you're getting "... terms must [not] be non-integer constants ..." instead of "no such column ...", but I think the first thing you should do is run 'pragma table_info' on your view to see what the column names are. I'll be surprised if there's a column named p.product_name.
It's a view that joins two tables.
Other problems with your query:
1. You don't need to call lower(). The like operator ignores case.
Doh, I didn't realize that!
2. It makes no sense to write '%%'. That gives exactly the
same result as '%'. If you're trying to limit your results
to 2-character strings, you want double underscore, not
double percent.
That is an automatically generated query and in that particular case the search string was empty (it would normally go between the %'s)..
Thanks!
-- - Mitchell Vincent
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
