select * from Customers
where PreferredName is not null