SQL SERVER If you determine that the text type data is not empty

The data type setting for a field remark is set to Varcharr (255), which is later considered to be defined as the text type for extensibility, but the SQL statement is an error.
SQL statements:
SELECT * from TABLE WHERE ISNULL (Remark, ') <> "
Error message: Data type text and varchar are incompatible in the not equal to operator.
Workaround: Use the datalength (field name) function
SELECT * from TABLE WHERE ISNULL (datalength (Remark), 0) >0

Note: 1. Datalength to varchar,varbinary,text,image,nvarchar , and ntext Data types are particularly useful because these data types can store variable-length data.
2. The result of NULL datalength is null.

SQL SERVER If you determine that the text type data is not empty