Length(string field) equal to 0 not works?

[SankaravelNa]

Hi All,

Length of string/varchar field equal to 0 condition check is not working in query filter activity? Is it product bug?

Thanks, Sankaravel N

[Amine_Abedour]

Hello @SankaravelNa;

Generally, Adobe Campaign stores empty character strings as NULL.
LENGTH(NULL) will return NULL, and thus those rows will not be included in the result set when you filter with LENGTH(varchar) = 0.
To include rows with NULL values, you need to explicitly check for them. In your query filter activity you should do something like (LENGTH(varchar) = 0 or varchar is NULL).

Br,

[LakshmiPravallika]

Hi @SankaravelNa ,

Please try with the query condition "columnname is empty" and let us know if you get the expected results.

Regards,

Pravallika.