Not knowing much at all about SQL Server, I was wondering if there is a way to find a record for the next field value.
Here is how I would do it in VFP:
Say I have field ORDER_NO, I, 4
Say I want to find a record after the record with ORDER_NO 100 (where I don't know if 101 exists):
set near on
seek 100 + 1
How would you do that in SQL Server?
Thank you.
P.S. On a related subject, why in VFP SEEK respects SET NEAR ON and SEEK() does not?
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham