I'm wondering if anybody knows a way to extract column names from a SQL query using asp. For instance say I do a ...<BR><BR>"Select * from MyTable"<BR><BR>I want to then find the column names from the returned recordset. Basically, I'm trying to create a web based Query Analyzer. If I submit a query using a form, then pop that query into a string, and open a recordset using that SQL statement. I need to find out the column names, and how many columns there to display the results in the browser.