Re: getting fields of a table(sql)

SELECT oneColumnIsAllYaNeed FROM TableName WHERE KeyField = 0 or SELECT * FROM TableName WHERE KeyField = 0 or maybe even...??? Havent tried this. SELECT oneColumnIsAllYaNeed FROM TableName WHERE KeyField = 0 You may also find Paul Hasting's post from the a

RE: getting fields of a table(sql)

Much easier Joe after you query, call query variable 'queryname.ComlumnList'. Will give you a comma delimited list of the queries column names -J -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, April 07, 2000 2:05 PM To: [EMAIL PROTECTED] Subject:

RE: getting fields of a table(sql)

Joe, SELECT syscolumns.name FROMsyscolumns INNER JOIN sysobjects ON sysobjects.id = syscolumns.id WHERE sysobjects.name = "Your_Table_Name" HTH, Sean. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, April 07, 2000 5:05 PM To: [