select CustomerID, isnull(PreferredName, Firstname) as FirstName, LastName
from Customers