Re: standard schemas for addresses, others?

Now THAT's a good idea, store a regex pattern for each country's zip code!

1/23/2003 10:01:19 AM, will trillich <will(at)serensoft(dot)com> wrote:
>
>
> insert into nations ( abbr,name,zips )
> values ( 'USA','United States of America','\\d\\d\\d\\d\\d(-\\d\\d\\d\\d)?' );
> insert into nations ( by,abbr,name,zips )
> values ( 'CANADA','Canada', '[A-Z]\\d[A-Z]\\s+\\d[A-Z]\\d' );
>