sql how to make a field with null empty string code example Example: t sql null or empty string select * from vendor where isnull(vendor_email,'') = ''