Hi,

Try something like this:

SELECT TOP 100 ... FROM ... WHERE custname (morethan) lcvarname ORDER BY custname

SELECT TOP 100 ... FROM ... WHERE custname (lessthan) lcvarname ORDER BY custname DESC

Union this cursors and reorder by custname ( not using UNION because must have ORDER BY in both SELECT ).