Subject Re: [ib-support] Key of varying length problem
Author Robert F. Tulloch
Hi:

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/