Thread

1. SQL Where Statement

   Michael <michael@wizard.ca> — 1998-06-06T11:03:58Z

   Might be a newbie question, but...
   
   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')
   
   Any help?
   
   
   

2. Re: [GENERAL] SQL Where Statement

   Marin D <marin@cybernet.bg> — 1998-06-06T14:42:13Z

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