How do I return last character in a string?

[SSgtBarry]

I have a field named "Document Number". It contains document numbers of various lengths/sizes, originating from various companies. I need to search for document numbers that might be the same, except they may have a suffix (last letter) that makes them different. Is there a way I can find these? Can I build a query that will show / cut off the last letter of a string?

Thanks in advance!

[orange]

Right(Trim(YourFieldName),1) will give the rightmost non-blank character

[June7]

Is the last character the only possible alpha? Can test if the entire value will evaluate as a number.

SELECT * FROM tablename WHERE Not IsNumeric(YourFieldName);

Or maybe you want to return all records with the same prefix part, disregarding the last character.

SELECT * FROM tablename WHERE [Document Number] LIKE [enter prefix part] & "*";

[SSgtBarry]

Thanks for the help! The Document Number could end in either a alpha character or numeric. No specific length.

[SSgtBarry]

@ Orange.... Thanks! I believe that does it!