Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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,
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,
yes it works,
Thank you very much Sunny