I am using the following query using distinct and like both, Can you please tell me am i doing something wrong, it is not getting the records.
But there are records which match the criteria:

###################################################################
Select distinct(a.title),b.docindex_i from ocrdata a,docudeck b ;
where a.tiffile = b.file_name ;
and a.ocdata like "%schedule%" ;
order by a.id into cursor lcsource
###################################################################

Thank you very much.