Thank you for your response. Do you mean sending 2 SQL commands, one for getting all the customers with the same name, if any, and the other getting next customer? Can you show me the latter one?
TIA
KM
>You can fetch all customers with the same name and navigate in the resulting dataset:
>
>
SELECT CustID, LastName, FirstName
> FROM Customers
> WHERE LastName = <lastname> and FirstName = <firstname>
> ORDER BY LastName, FirstName
HTH
>
>>The customer table of my SQL server database contains the following 3 column. There may be more than one customer having exactly the same last and first names while CustID is unique:
>>CustID, LastName, FirstName
>>
>>Data currently showing in my "Customer Data" form are
>>CustID=671
>>LastName='Barnes'
>>FirstName='John'
>>
>>What is the best SQL command to get the CustID of next (alphabetic order) customer?