On Thu, Jan 23, 2003 at 10:56:27AM -0800, Dennis Gearon wrote:
> 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@serensoft.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' );
i only bother taking credit for ideas which don't seem obvious
to me. this one sure did.
i'll make an exception in this case. glad to have contributed!
:)
--
There are 10 kinds of people:
ones that get binary, and ones that don't.
will@serensoft.com
http://sourceforge.net/projects/newbiedoc -- we need your brain!
http://www.dontUthink.com/ -- your brain needs us!
Looking for a firewall? Do you think smoothwall sucks? You're
probably right... Try the folks at http://clarkconnect.org/ !