I have around 1000 Records in a file. The file has a field PS, In certain records I have a text 'T M' in the middle and the last three words are 'g n'.

Using the following function I am able to locate the PS having 'T M' and 'g n' at the last three digits. But the problem is my below mentioned code locates the first instance of T M and g n , while I need the record number of the last occourance of T M and g n.

I.e I mean to say that I need the last record number whic has the above text.

Is there any way that locate function finds from bottom to top or any other way

Here is my code

LOCATE FOR AT('T  M',PS)>0 AND RIGHT(ALLTRIM(Ps),3)='g n'
IF FOUND
lrecordno=RECNO()
ENDIF