I have the following query (I have removed all nulls from the field as test) SELECT first_name,work_email FROM tb_contacts WHERE tb_contacts.work_email <>''; However I get loads of blank email addresses coming up anyone any ideas ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx