A
Anonymous
Guest
why not lower(type) , when that is what you are matching... ?How can I get the query to return all records containing "widgets" regardless of which letters are capitalized? I tried using LOWER(category) with no success.