Yes, but you need to distinguish each 'contains'. eg.
where contains(tblPrograms.Name, searchstring,1) > 0 and
where contains(tblItems.Content, searchstring,2) > 0
notice the '1' and '2' are used to distinguish
>Is it possible to have a search like :
>select tblItems.ID, tblItems.Content, tblPrograms.Name from ....
>where contains(tblItems.Content, searchstring) > 0 and
>contains(tblPrograms.Name, searchstring) > 0
>
>
>Thanks in advance.
>
>Koen
>Koen.VanTolhuyzen_at_cronos.be
>
>
>
Received on Fri Nov 26 1999 - 07:45:32 CST
