Subject | Re: [ib-support] Key of varying length problem |
---|---|
Author | Robert F. Tulloch |
Post date | 2001-11-10T15:36:58Z |
Hi:
What do these things really look like and what do they mean?
In the us, the zip code means something.
What do these things really look like and what do they mean?
In the us, the zip code means something.
> The postal_zone contains a key, that is part of a postal code, it
> might be X1X 1X1, X1X 1X, X1X 1, X1X, X1 or X
>
> say I have the following zones:
> 1 X1X 1X1
> 2 X1X 1X
> 3 X1X 1
> 4 X1X
> 5 X1
> 6 X
>
> I have the following postal codes
>
> X1X 1X1 must match 1 but not 2,3,4,5 or 6
> X1X 2E4 must match 4 but not 1,2,3,5 or 6
> X3F 2Z7 must match 6 but not 1,2,3,4 or 5
>
> I am at a loss on how to do this, I can't use another key, because
> a new zone could be added at any time, and I don't want to have to
> scan the Postal code file and relink it. I will if I have to, but would
> rather not.
>
> Paul
>
> Paul Schmidt
> Tricat Technologies
> paul@...
> www.tricattechnologies.com
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/