Try this to determine what the end character is.

SELECT ASCII(RIGHT(<your column>,1)) FROM <your table> WHERE <some selection criteria>