set null ' '
J
At 11:55 AM 3/2/2005, you 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 Rugilo
