Hi-
If I want to search a text field for a certain word, say 'foobar', using:
SELECT * FROM mydb WHERE description LIKE "%foobar%";
it seems to be case sensitive. Is there a way to do it so it is NOT case-sensitive?
Please let me know.
Thanks,
Mike
mike(at)fieldco(dot)com