I am trying to get the numeric position of a string inside a string. The string looks like this:

"CHANGE ORDER 01CHANGE ORDER 02CHANGE ORDER03"

The string to search is "CHANGE ORDER". I want to get the right most string position, which in this case should be 31, but it comes up as zero (0) when I use the following code:

lcComments = "CHANGE ORDER 01CHANGE ORDER 02CHANGE ORDER03"

lnLastStringPosition=RAT(lcComments,"CHANGE ORDER")

?lnLastStringPosition

Why this comes out as a value of 0, I do not understand.

Perhaps my 10-mile hike with my son and his SCOUT Troop this past weekend in Joshua Tree, California, has affected my mental skills.