I am trying to create a Select statement to get any records where a text field is not blank. For a character field, I can do:

SELECT field1 FROM table1 WHERE LEN(field1) > 0

but if I try to do the same thing with a text field, I get:

"Argument data type text is invalid for argument 1 of len function."

How do I test the length or not empty of a text field? Thanks in advance for any assistance.

Kind Regards,

Mat