[RBG7-L] - Re: Computed column

[Jan Barley]

Robert, Can you use   (ifgt((slen(houseno)),0,(ctxt(houseno))&streetname,streetname)) ???   Jan Barley   ----- Original Message ----- From: Robert Rugilo To: RBG7-L Mailing List 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

<<BackGrnd.jpg>>