roy simkes wrote:
> Is there a way that select's where clause can be used as insensitive to
the case? I mean:
> "SELECT * FROM table WHERE field LIKE 'f' " will return every row that
field begins with a "f" or a "F". Without writing " field LIKE 'f' OR field
LIKE 'F' " of course.
try:
"SELECT * FROM table WHERE LOWER(field) LIKE 'f'"
or:
"SELECT * FROM table WHERE LOWER(field) LIKE LOWER(x)" <-- if using
variable "x"