Select command using right

[RBtools]

I am having a problem with a select command.

select * from ReportTCP where Right(UserName,2) like  '24'


I want to find all of the UserNames that end in 24.  Every time I try this I
get nothing back from the database.  I know that I have at least one
UserName that ends in 24.

UserName is a string[64] and the name that I am looking for only has 4
characters in it.

Thanks for the help,

Steve