>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

In addition to what the others have said, you might want to look at SET NEAR and SET EXACT for this situation.

Bill