select * from Customers
where not (PreferredName is null)