On Sun, Dec 07, 2003 at 12:11:21AM -0500, Alex Khordos wrote:
>
> I am trying to work out the query to retrieve city name based on the zip
> code in the second table.
> How can I compare two strings? I tried LIKE in my query but it did not work.
Use SUBSTRING to cut down the extended zipcode to 5
Hello All
I have two tables
Table: 1
+---+--+
| city | zip_code |
+---+--+
| New York | 12354|
| New York | 12355|
| New York | 12356|
| New York | 12357|
| New York | 12358|
| New York | 12359|
| New York | 12353|
+--