"STRING" in a WHERE clause of FILTEER Stage

[Camaj]

Bonjour,

I would like to use a STRING comparaison in a WHERE clause of FILTER stage but the result is always empties.

The comparaison field is CHAR(10). When I use a numeric field every thing is working fine, but with a CHAR I got anything.

ACTY_TYP='FLIGHT' (ACTY_TYP is CHAR) does't work but MKTG_PGM_ID=3537 (MKTG_PGM_ID is INT) is working fine.

Somebody can help me !

[vmcburney]

Is your field trimmed? I would expect a char(10) to come through as "FLIGHT " or " FLIGHT" instead of "FLIGHT".