[RBASE-L] - RE: postal service zipcodes

[Javier Valencia]

Sure you can… If the zip code column name = c_zip And the extension column name = c_ext Then create an _expression_ on your label: V_zip = (IFNULL(c_ext, c_zip, (c_zip + ‘-‘ + c_ext)) This assumes that c_zip and c_ext are text, if they are integers then use: V_zip = (IFNULL(c_ext, CTXT(c_zip), (CTXT(c_zip) + ‘-‘ + CTXT(c_ext)) ) the _expression_ checks if the zip extension is null; if it is, it returns only the zip code, if it is not it returns the zip and extension with a hyphen in between. If you use variables, make sure to use a dot (.) in front of the variables.   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: rbase-l@rbase.com [mailto:[EMAIL PROTECTED]On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, May 04, 2005 12:58 PM To: RBASE-L Mailing List Subject: [RBASE-L] - postal service zipcodes   Our database has 1 column for the 5 digit zipcode and 1 column for the 4 digit extension. The 4 digit extension is sometimes blank - unknown. I have been printing mail lables with these two columns separated by a space. Our local post office has informed us that this is not acceptable for their scanning equipment. There must be a hyphen between the two when both are present. Of course this is easy, except when the 4 digit extension is blank, then the hyphen should not be present. Can I use a variable _expression_ for this?