show Unknown if IsNull(@48) or @48=' '

[Anonymous]

I want to add an 'Unknown' selection to the field @48

I have the following script that is not working yet:

if(isnull(@48),'Type Unk',

if(@48 = ' ','Type Unk',@48)) as DebtorType,

is there something I can change here, or a different way to get the result I want?

[MayilVahanan]

HI

Try like this

If(Len(Trim(@48)) = 0 ,'Type Unk',@48) as DebtorType;

Hope it helps

[#3]

Try:

if(isnull([@48]),'Type Unk',

if([@48] = ' ','Type Unk',[@48])) as DebtorType,

[Anonymous]

thanks for your help, managed to figure it out right after I posted!