retrieving only the column label

From: Lee, Seung K. <vrman_at_sl2sys.co.kr>
Date: Sun, 11 Mar 2001 01:49:21 +0900
Message-ID: <98dlff$7s7$1@news2-2.kornet.net>

Good day group...

here's my problem

All I want the query to return is just the column label, preferably with a delimiter I can assign.

Let me elaborate.
I have

select col1 as NAME, col2 as EMAIL from TABLE;

it would give

NAME EMAIL

---

Leee Lee_at_somewhere.com
........
........

I just want "NAME and EMAIL". Straight forwardly anything after AS. If possible with a delimeter ,(comma)
which would give name,email. Don't need the query result.

I need this because we're working with various databases and they have different column name for obviously same content and we want to unify it.
We're doing this with a c program. I guess I can string compare the query sentence and pick out the aliases but I thought there must be a better way...

Well~ if this is a one of those question that always comes up... My apologies but I've really gone though the doc's I've got. TIA Received on Sat Mar 10 2001 - 10:49:21 CST