POSTAL CODE

I have a table in DB

Province PostalCodeFrom PostalCodeTo ORIGIN

QC G0A GOG 14

QC G5B G5H 15

QC G6Z G6Z 13

How ido by sql or winform (vb.net) to do a look-up like

I enter G5D and a result is 15

I enter G0E and a result is 14

This is for Canadian Postal Code.

I'm looking for to American Zip code too. like example

FL 111 222 34

FL 555 689 55

Thanks very much for every body can help me.

[467 byte] By [npham] at [2007-12-24]