|
you can do something like this with a select statement to get the entended
results
select ifnull(exten,thezip,thezip+'-'+exten) from zipcode
thezip being the 5 digit zip and exten being the 4 digit extension (:
----- Original Message -----
Sent: Wednesday, May 04, 2005 10:58
AM
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?
|
