Обсуждение: Like and Not LIke

Hi List,

I need a simple query which incorporates this sort of logic.

Filename is like filter1 but not like filter 2

Its easy enough to do Filename ILIKE '%filter1%, but I've not been able to find
the syntax to complete the logic.

Any help appreciated.

Regards

Richard

On 9 October 2010 15:45, richard terry <rterry@pacific.net.au> wrote:
> Filename is like filter1 but not like filter 2
>
> Its easy enough to do Filename ILIKE '%filter1%, but I've not been able to find
> the syntax to complete the logic.
Filename  ILIKE '%filter1%' AND Filename  NOT ILIKE '%filter2%'
?