replacing blank value with string

[#1]

hi QV,

how do we handle blank values in Qv,

I have a field like DEL_BLOCK,some of that fields records coming as blank from DB.so I want to assign a string for blank values.

looks below is the cond i have used,is it fine??

If(IsNull([DEL_BLOCK]=' '),'Free','Blocked') as Blocked

Thanks

[Anonymous]

try with

If(len([DEL_BLOCK])=0,'Free','Blocked') as Blocked

Marc.

[Clever_Anjos · Accepted solution]

Please use TRIM, since you could have spaces into your field

If(len(trim([DEL_BLOCK]))=0,'Free','Blocked') as Blocked

[JonnyPoole]

NULL is different to blank. Its a long story...

NULL:

If(IsNull([DEL_BLOCK]),'Free','Blocked') as Blocked

Blank:

If([DEL_BLOCK]='','Free','Blocked') as Blocked

or like clever said

If( trim([DEL_BLOCK])='','Free','Blocked') as Blocked

or like marc said

If(len([DEL_BLOCK])=0,'Free','Blocked') as Blocked

[Anonymous]

If(IsNull([DEL_BLOCK]),'Free','Blocked') as Blocked