82bbf24b   
   From: akm@in-press.co.uk.invalid   
      
   Maybe this'll give you an idea:   
      
   declare @LastIssue int;   
   select @LastIssue = 9;   
      
   select n from   
   (select 1 as n   
   union select 2   
   union select 3   
   union select 4   
   union select 5   
   union select 6   
   union select 7   
   union select 8   
   union select 9   
   union select 10   
   union select 11   
   union select 12) as t   
   where n < @LastIssue   
   except   
   (select 2 as n   
   union select 3   
   union select 5   
   union select 7)   
      
   -- outputs 1 4 6 8   
      
   HTH,   
      
   Andrew   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)