>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?

SELECT TOP 1 * FROM SQLTable WHERE ORDER_NO>100