Nulls or Space or ??

[tmumaw]

I have a field that I have tried

if(Len(Trim(ZZCANCEL_STATUS]  > 0),1,0) as Can_SW

If(IsNull([ZZCANCEL_STATUS]) ,0,1) as Can_SW

Neither one works any ideas?

Thanks

[avinashelite · Accepted solution]

try like this

if( Len(Trim (ZZCANCEL_STATUS ) ) > 0,1,0) as Can_SW

[Anil_Babu_Samineni]

First one should be this? And second one okay to me

if(Len(Trim([ZZCANCEL_STATUS]))  > 0,1,0) as Can_SW

[its_anandrjs]

This way try

if( Len( Trim(ZZCANCEL_STATUS])  > 0,1,0) as Can_SW

Or

If( IsNull ( [ZZCANCEL_STATUS]) = -1 ,1,0) as Can_SW

[sunny_talwar]

May be this

If(Len(Trim(PurgeChar(ZZCANCEL_STATUS, chr(32) & chr(160)))) > 0, 1, 0) as Can_SW

chr(32) + chr(160) as spaces in string. How to eliminate in one step?

[tmumaw]

Thanks worked perfectly