RE: SQL before & after

["Henza, Guy" <GHenza@xxxxxxxxx>]

OK, I did it ugly;

SELECT RRN(a) RRN, a.IQDBSQ, a.IQDREC, a.IQDDTA       
  FROM G3X1DTA/INBDTA a                               
 WHERE RRN(a) in (SELECT RRN(b)                       
                    FROM G3X1DTA/INBDTA b             
                   WHERE b.IQDBSQ > 56000             
                     and (b.IQDDTA like '%QTY¬32¬-%'  
                      or  b.IQDDTA like '%QTY*32*-%'))
    or RRN(a) in (SELECT RRN(c) - 1                   
                    FROM G3X1DTA/INBDTA c             
                   WHERE c.IQDBSQ > 56000             
                     and (c.IQDDTA like '%QTY¬32¬-%'  
                      or  c.IQDDTA like '%QTY*32*-%'))
    or RRN(a) in (SELECT RRN(d) - 2                   
                    FROM G3X1DTA/INBDTA d             
                   WHERE d.IQDBSQ > 56000             
                     and (d.IQDDTA like '%QTY¬32¬-%'  
                      or  d.IQDDTA like '%QTY*32*-%'))

'%QTY%%%%-%' wasn't giving me the desired data either.

Guy