>Hi all,
>
>Is there an equivalent function in SQL7 to VFPs AFIELDS()?
>
>Thanks...
>
>Keith

Although it won't return an array, you can try:

Select * From information_schema.columns Where table_name='mytable'

If you are using SPT there is also SQLTABLES() and SQLCOLUMNS()
HTH