Our addresses are stored in our database using the postal standards; however, on some occasions our users need the address in the formal format (ex: St. needs to be written out Street, full names of states, etc). I am sure we can do this with a series of defines as well as joins to our validation/lookup tables, but I was just wondering if anyone is doing something like this and has any suggestions as to the best way to do it?

Thanks in Advance!

This message has been edited. Last edited by: <Kathryn Henning>,

You can use DECODE with a file. Where the file contains the pairs of values, such as 'St.' 'Street', etc. The USPS site may have official list of these.

This message has been edited. Last edited by: Doug,

Yes they do:

USPS Abbreviations

Thank you!