Character Search in Variable Length Field

Hi All,
 I have a need to find a specific character in a variable length field.  This field ends with an account number, which is 10 digits long.  I need to report on all records that have an account number that begins with an '8'.  I've tried using the Right() Function with no success.  Since the field ends with the account number, the position I need to search on will always be in the 10th position from the end of the field.  Has anyone had to do a similar task?

Thanks in advance!
Frank

mid({table.acctnum},len({table.acctnum})-9,1)='8'

Seems to be working great.  Once again I thank you for your help!