It's possible but maybe slow if table is big.
lcCompId = "12345678"
SELECT * FROM mytable ;
WHERE (lcCompId $ varEng) ;
OR (lcCompId $ varEng) ;
OR ...
>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
--sb--