Re: [GENERAL] SQL Where Statement

On Sat, 6 Jun 1998, Michael wrote:

>
> I am trying to do a select with a WHERE clause excluding all fields that
> don't start with 'A'..'Z'
>
> Something in the form of
> WHERE lastname
> NOT LIKE ('A'..'Z') AND
> NOT LIKE ('a'..'z')

SELECT *
FROM somewhere
WHERE lastname !~ '[A-Z]' AND lastname !~ '[a-z]';

will INCLUDE the fields that *don't* start with A-Za-z while

SELECT *
FROM somewhere
WHERE lastname ~ '[A-Z]' AND lastname ~ '[a-z]';

will EXCLUDE the fields that *don't* start with A-Za-z

Hope this helps...

Marin

-= Why do we need gates in a world without fences? =-