All,

I have a SQL Select for putting all my records in a cursor, and I need to do some search in the cursor.

I''m be able to use LOCATE to look for a certain record but couldn't use SEEK or FIND because both of them need an index tag. I need to search for the nearest matched record in the cursor in case LOCATE fails.

Any solution for this?

Thanks.
Gan