Simple SQL Question

[Quoted] Is there a simple way to query a table whose records are formatted as follows:

FIELD1    VARCHAR(12)   -   Ex. Data: NORTH
FIELD2    VARCHAR(12)   -   Ex. Data: 1000
FIELD3    VARCHAR(12)   -   Ex. Data: 2000
FIELD4    VARCHAR(12)   -   Ex. Data: 3000

with a result set that contains multiple records in the following format:

NORTH 1000
NORTH 2000
NORTH 3000 without doing a UNION? We're trying to avoid changing the table structure and the overhead of runniing UNION statements.

Thanks. Received on Wed Feb 14 2001 - 00:11:19 CET