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>>

Reply via email to