>>What would be a Code to search a table for a value and return the fieldname containing that value, (perhaps multiple fieldnames, perhaps multiple records)?
>
>start with:

>llFound = .f.
>for i = 1 to fcount()
>  if type(field(i)) = "C"
>     if somevalue $eval(field(i))  && might want to use upper() on both
>        llfound = .t.
>        exit
>     endif
>  endif
>next
>if llFound
>   return field(i)
>else
>   return .null.
>endif

sorry. To search the table:

locate for somevalue $eval(field(i))
if !eof()

etc...