Robert:

You probably have ZERO set to ON; you need to set:

SET ZERO OFF

Otherwise it evaluates the NULL as 0 (zero)

Javier,

 

Javier Valencia, PE

President

Valencia Technology Group, L.L.C.

14315 S. Twilight Ln, Suite #14

Olathe, Kansas 66062-4578

Office (913)829-0888

Fax (913)649-2904

Cell (913)915-3137

================================================

Attention:

The information contained in this message and or attachments is intended

only for the person or entity to which it is addressed and may contain

confidential and/or privileged material.  Any review, retransmission,

dissemination or other use of, or taking of any action in reliance upon,

this information by persons or entities other than the intended recipient

is prohibited. If you received this in error, please contact the sender and

delete the material from all system and destroy all copies.

======================================================

 

-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED]On Behalf Of Robert Rugilo
Sent: Wednesday, March 02, 2005 10: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

 

 

 

 

<<image001.jpg>>

Reply via email to