Submissions are now open for the 2026 Adobe Experience Maker Awards
SOLVED
Length(string field) equal to 0 not works?
1 Accepted Solution
Correct answer by
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,
Correct answer by
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,
Related Conversations
