select top 1 *
from Customers
where LastName = 'Smith'