Did you consider adding it to the FAQ section?
>All,
>
>I was reading SQL Magazine and an article by Brian Moran solved a problem I had. The problem was "How do I get the record right before and right after some seed value?"
>
>His solution was a creative use of the MIN and MAX functions of SQL. I paraphrase his TSQL code into VFP:
>
>This is the code:
>
>SELECT * from wotype WHERE wotype.wotype_id = "0000000009" OR wotype_id IN(SELECT MAX(wotype_id) FROM wotype WHERE wotype_id < "0000000008") OR wotype_id IN(SELECT MIN(wotype_id) FROM wotype WHERE wotype_id > "0000000008")
>
>
>SELECT * from wotype WHERE wotype.wotype_id = "0000000009" && seed value ; OR wotype_id IN(SELECT MAX(wotype_id) FROM wotype WHERE wotype_id < "0000000008") && Gets the max value of the subset of values that are less than the seed value.
>OR wotype_id IN(SELECT MIN(wotype_id) FROM wotype WHERE wotype_id > "0000000008") &Gets the min value of subset of values that are greater than the seed value.
>
>Works as advertised. This solution gets me the value right before and right after my seed value of "0000000009".
>
>
>Great work Brian!
--sb--