Field Names From SQL Statement

Is there anyway to determine what the resulting Field Names are going to be from a SQL Statement?





For example:


SELECT TABLE1.FIELD1, TABLE1.FIELD2, TABLE1.FIELD3, TABLE2.FIELD1 AS ANOTHERNAME


FROM TABLE1 INNER JOIN TABLE2 ON TABLE1.PK = TABLE2.FK





resulting field names:


FIELD1


FIELD2


FIELD3


ANOTHERNAME





Seems easy enough splitting all values before "FROM" by comma and doing some manipulation to remove table names and anything before the word "AS". However, it gets more difficult when you have complex CASE statements embedded in you query that may also contain commas.





Just a shot in the dark because I don't know if anyone has already done something like this before.





Thank you in advance,





Jeff