There is no bug. You want case-insensitive pattern matching, which is
not what your call to "tolower()" accomplishes.
The query
SELECT company from user_tbl where company like lower('%SEaN%');
will find all strings which contain "sean" (note case!). It will not
match strings containing "Sean". Look in the PostgreSQL docs for hints
on how to do case-insensitive searches.
- Thomas
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
