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? =-
