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
