Try

SET @LastFirst = @LastName + @FirstName   -- from the previous record.
SELECT TOP 1 *
FROM yourTable
WHERE LastName >= @lastName
 AND FirstName >= @firstName
 AND LastName + FirstName > @LastFirst 
 ORDER BY lastname, firstname
-- or
SELECT TOP 1 *
FROM yourTable
WHERE LastName >= @lastName
 AND FirstName >= @firstName
 AND custID <> @custID
 ORDER BY lastname, firstname

>Dear Michael,
>
>Thank you for your response. However I am afraid the command may not be able to return the correct record since the following customer will not satisfy the WHERE condition of the SQL even if it is actually the alphabetical next.
>CustID=73, LastName='Barret', FirstName='Amy'
>
>KM
>
>