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