[RBASE-L] - RE: postal service zipcodes

[Dawn Oakes]

Yes.  Say the zipcode field is called zipcode and the 4 digit extension field is called zipext   set var vzipcode = (ifnull(zipext, zipcode, (zipcode + '-' + zipext)))   This assumes both fields are text.  The _expression_ says, if the extension field is null, just show the zip code, if it's not, concatenate the zipcode, the dash and the extension.   Dawn From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 04, 2005 1: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?