Change your Computed column to include the "(IFNULL(arg1,arg2,arg3))" function something like:
((IfNull(houseno,null,(ctxt(HouseNo)))) & Streetname) ----- Original Message ----- From: "Robert Rugilo" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[email protected]> Sent: Wednesday, March 02, 2005 11:55 AM Subject: [RBG7-L] - Computed column I have a table which contains a field called HouseNo int, StreetName Text and a computed column named FullAddress (computed as ((ctxt(houseno)) & Streetname) 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 any ideas ? Robert Rugilo
