At 11:55 AM 3/2/2005, Robert Rugilo wrote:
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,
Check your database settings for ZERO and EQNULL.
SHOW ZERO SHOW EQNULL
Try your calculation with the following settings and see what you get:
SET ZERO OFF SET EQNULL OFF
Hope that helps!
Very Best R:egards,
Razzak.
