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