Simple SQL Question

From: Jeff Anderson <jeanderso9_at_yahoo.com>
Date: Tue, 13 Feb 2001 23:11:19 GMT
Message-ID: <raji6.127909$9v2.1661044@quark.idirect.com>

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 Tue Feb 13 2001 - 17:11:19 CST