> Basically This query will give you the column names: > > SELECT name FROM syscolumns > WHERE id = (SELECT id FROM sysobjects > WHERE name= '<TableName>') > ORDER by colorder; wrong DBMS ;o) ------------- rudy http://r937.com/ | http://rudy.ca/ pre-order my book "Simply SQL" from Amazon -- http://www.amazon.com/exec/obidos/ASIN/0980455251/