>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
>###################################################################

Hi Raj,

Can you change the aliases, a and b, to something else? Perhaps VFP is looking at work areas 1 and 2.