anyway to check if a text field is blank (not null but just a empty string '') ?

i have a trigger on a table right now... when fields are inserted, theres a text field inserted and i want to check if that text field = '' (the empty string, not NULL) and if it doesn't equal that, then perform some row updates on other tables, but if it is empty, to not do anything else in the trigger... right now i have this:



Note is the text field, XATPoDetail is the table where its being inserted into. I had to do the select FROM the table because it wouldn't let me select a text data type from the "Inserted" virtual table

but it tells me me "Error 279: The text, ntext, and image data types are invalid in this subquery or aggregate expression"

thanks

How about using DATALENGTH(Note) ? This will give you the number of bytes in the field. In the case of text, the number of bytes is the number of characters.
You coulc use DATALENGTH(Note) > 0 instead of comparing to a null string.

not sure what ur asking stricly speaking but the easiest way..

if not isnull(fieldname)


would be what ur looking for