how to test blanc and null values in script

[doespirito]

hi every body,

here is a qw file in witch i try to test blanc or null value :

if INSEE = blanc or null then CODE_DEP_ZMSD = 'HZ'

if CODE_CANTON blanc or null then CODE_CANTON ='9999'

i've tried ='', =' ', isnull but it doesn't work.

Have somebody an idea ?

Thank you very much in advance,

Arnault

subsidiary question : why chek box for CODE_DEP_ZMSD doesn't contain a blanc line ( like CODE_CANTON) while it contains blanc or null values.

[sunny_talwar · Accepted solution]

May be try these

if (Len(Trim(INSEE)) = 0,'HZ',CODE_DEP_ZMSD) as CODE_DEP_ZMSDc,

if (Len(Trim(CODE_CANTON))=0,'9999',CODE_CANTON) as CODE_CANTONc,

[doespirito]

yes it works,

Thank you very much Sunny