[RBG7-L] - RE: Computed column

[Dawn Oakes]

Robert,   Set Zero Off   with zero set on, it treats nulls as 0 in calculations.   Dawn From: Robert Rugilo [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 02, 2005 11:55 AM To: RBG7-L Mailing List 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

<<BackGrnd.jpg>>