Query Part of a Field

[EHittner]

I'm looking for a way to query part of a field that contains a string of characters with spaces. I want to return the last section of the string after the final space. Example: "USER MALORY IGNACIOUS IMUSER" I want the query to return the part of the string at the end - or "IMUSER".

The length of that part of the string will vary in length, depending on the length of the user's last name.

How do I pick that part of the field out for my results?

[orange]

Research InstrRev() function
and look for the first space " "