On Sun, 2004-05-16 at 20:19, ljb wrote: > You almost got it - just do "select * from tablename where 0=1", which returns > no rows but will give you the fieldnames. A portable and (I think) > efficient way to get table column names. Thanks. That should do it. I was not able to get to the list archives earlier. -- Scot L. Harris <webid@xxxxxxxxxx>