>Dear all,
>How do I check whether a particular column exist in a table? Tried field() but I only know the name of the column and not the position.
>Thanks in advance.
>Yau

An alternative method to Borislav's is:

Select YourTableAlias
lnNoFields       = FCOUNT()
I                = 1
llFound          = .F.
Do while I <= 1 lnNoFields ;
   and not llFound
  If FIELD( I) = lcYourColName
      llFound    = .T.
  Else
      I          = I + 1
  EndIf
EndDo