Select command using right

[Yennie at aol.com]

I think you are looking for this:

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

HTH.
Brian

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