Danny,

Yes, that does help! But I am not getting what I expected? The select is returning records where the text fields that are empty too. I am wondering if checking the length is wrong and if there is a better way to test whether there is any actual text (non spaces) that have been entered. Thanks for your assistance.

Kind Regards,

Mat

>Matthew,
>
>On SQL Server you must use DATALENGTH rather than Len for Text Fields...
>
>Hope that helps...