Length(string field) equal to 0 not works? | Community
Skip to main content
SankaravelNa
New Participant
December 30, 2024
Solved

Length(string field) equal to 0 not works?

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
Amine_AbedourAccepted solution
New Participant
December 30, 2024

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,

Amine ABEDOUR
View reply

2 replies

LakshmiPravallika
LakshmiPravallika
New Participant
December 31, 2024

Hi @sankaravelna ,

 

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

 

Regards,

Pravallika.

Translate
Amine_Abedour
Amine_AbedourAccepted solution
New Participant
December 30, 2024

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,

Translate
Amine ABEDOUR
    Terms & ConditionsAccessibility statement

    Loading footer...