> whenever the field of houseno is null the full address results is 0 > streetname it seems that when we compute the null becames a 0
You have ZERO set ON, as other people have mentioned. However, if you SET it OFF, you will likely find that other parts of your program fail (unless you have carefully programmed around this issue). You might try: (IFNULL(HouseNo, '', CTXT(HouseNo)) which may avoid the "expressionization" of HouseNo in the first argument of the function call (do NOT put an extra set of parens around HouseNo in this case). If not then: (IFGT(HouseNo, 0, CTXT(HouseNo), '')) should work. It will definitely (he said recklessly) work with ZERO ON and, I think, it will also work with ZERO OFF. But if it doesn't work with ZERO OFF, then you need to get persnickity: (IFNULL, HouseNo, '', IFGT(HouseNo, 0, CTXT(HouseNo), '')) should work in all situations. -- Larry
