Hi Bill,

In fact, I already solved this for myself by using another(shorter) field. In fact, I was using the wrong field from the beginning. You cannot use expressions (like left(field2,240)) in subqueries, this will always give the SQL correlation error. You can try to run a simple query first, selecting left(field2,240) as c1 and right(field2,16) as c2 and the run the same query using this cursor (in the subquery use a.c1=b.c1 and a.c2=b.c2). This should work, though I haven't tried it.

Auke


I'm sorry Auke, I don't know. I duplicated your results but I don't know off hand what to do to correct this. I tried using left(field2,240) on field2 but this gave a SQL correlation error. Same when I created an index on left(field2,240) then queried on left(field2,240). I must be missing something here.

Perhaps someone else has seen this and will jump in