Best way to get right n digits from number in SQL Server (CE)

Question

I have a sql server compact framework database and I want to query an int column

the column can contain values from 1 to 99999999 and I am interested in the right 4 digits

Examples:

     1 ->    1
    12 ->   12
   123 ->  123
  1234 -> 1234
 12345 -> 2345
123456 -> 3456

I could convert the result to string and use substring, but there is propably a better solution.

Answer 1

Use Modulo

 select 123456 % 10000

SQLFiddle demo

Answer 2

If you

SELECT WhateverField % 10000

you will get the 4 rightmost digits.