Is it possible to create a SELECT-SQL statement that will return records based on the content of a memo field?

For example, I have a table as follows:

projectid C(15)
varEng M
varContr M
etc..

The varEng and VarContr memo fields contain a number of company ids or may possibly be empty. I would like to be able to select only those projectids that contain a particular company id in atleast one of the memo fields. I hope this makes sense. Any suggestions would be greatly appreciated.

Thanks in advance,
Russell