>>
>>Only one ORDER BY is allowed per UNION. You can use derived tables to get around it
>>

>>SELECT * FROM (select TOP 50 * from MyTable where PK_VAL > nVar Order by PK_VAL) dt1 ;
>>UNION ALL ;
>>SELECT * FROM (select TOP 50 * from MyTable where PK_VAL < nVar Order by PK_VAL DESC) dt2
>>

>
>Thank you very much for the suggestion.

You're welcome