I am trying to remove the last 2 characters of a string field.
there is no consistant length in the field
i want to remove everything after R
i tried instrrev but i that didnt do it.
is there a way to say
start position1 and go the R