select field names

[aas4mis]

Is it possible to select a tables field names using standard sql? [no vb]

[janders468]

Could you give me an example of what you're trying to do? If you just want it to display the field names but return no records then put an unsatisfiable condition in the Where clause i.e. SELECT * FROM relevanttable WHERE 1=2, but it sounds like you might be trying to get field names as a list of rows?

[NeoPa]

What do you mean by "Select" in this context?

[salimudheen]

Hey,
U can give the field name to the sql query. For eg,
Select field1, field2, field3 from Table1 Where field1=Val1

[hellojinesh]

I have to select field names from a table using query
is it possible???
means
A select query is to select field values
but i have to select field names

[janders468]

If you want to return the field names as the result of a query i.e. if you have a table with Field1, Field2 and you want to return something like:

Fields
Field1
Field2

I don't know of a way to do that using a query. You would have to use a recordset or some other mechanism to do the transposition. It's possible, and not that difficult, but it cannot be done with SQL alone.