RE: SQL before & after

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

Rob,

Thanks for the reply.  No, I didn't mean images.  Maybe I should have
said prior/next. 
I remember using a SELECT statement and getting the record WHERE
something = something else.  Then adding to the select statement and
getting record(s) prior and record(s) subsequent to the = condition.  I
didn't have a business application so I was just playing with it for a
few minutes. At first I got 1 record before and after the = then I got 5
records before and 3 records after.  I'm sure I got it off of one of
these midrange lists.
 
Regards, 
 
Guy 

----------------------------------------------------------------------

date: Fri, 3 Feb 2006 15:43:07 -0500
from: rob@xxxxxxxxx
subject: Re: SQL before & after

When I think of "before and after" I think of the before and after
images 
that are part of the parameter passed to a trigger program when an
update 
occurs to a record.  What are you thinking of?

Rob Berendt