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