>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