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