From: DOCloudsNOT@hardwareSPAM-spot.com   
      
   Hi all,   
      
   Just wondering if it is possible to compare against multiple values _with_   
   pattern matching?   
      
   Example:   
      
   SELECT *   
    FROM dog   
    WHERE NAME LIKE 'A%Z'   
     OR NAME LIKE 'B___'   
     OR NAME LIKE '%C%'   
      
   turns into something like this   
      
   SELECT *   
    FROM dog   
    WHERE NAME IN('A%Z', 'B___', '%C%')   
      
   Of course last query won't work, but is there something like this that   
   doesn't need the "OR"s from the first query?   
      
   Thanks for any hints....   
      
   --   
   Clouds®   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)