Re: Case Sensitivity in selects

[Felix Geerinckx]

Tristan Gutsche wrote:

> Is there a function where i can set a search criteria to be case insensitive?
> eg: select img_id, img_title from images where img_filename LIKE setCase(Insensitive,
> '%portugal%');


LIKE comparisons are not case sensitive by default:

SELECT 'abc' LIKE 'AB%'; -> 1

What is the datatype of your img_filename column?

--
felix
Please use BBCode to format your messages in this forum.