Field Values - or Null or 0 Replacement

[#1]

Hi Experts,

I want to replace a field values like - , Null or 0 by 1. which function should i use to replace Null or 0 value by 1 ?

Thanks & Regards,

[sunny_talwar]

May be like this

If(Field = 0 or IsNull(Field) or Len(Trim(Field)) = 0, 1, Field) as Field

[rupamjyotidas]

If(Match(Field,0,'-')>0 or IsNull(Field) or Len(Trim(Field)) <1, 1, FieldName) as FieldName