The RIGHT function returns different results for different datasources. Some of those results are inconsistent with definition of the RIGHT(x,y) function.
=======
*Query: SELECT intkey, RIGHT(intkey, 1) FROM table ORDER BY intkey*
*Teradata, SQLServer, Sybase, Ingres, MySQL, Oracle (this result is OK):*
0	0
1	1
2	2
...
10	0
11	1
...
100	0
101	1
*Postgres:*
0	0
1	1
2	2
...
10	10
11	11
...
100	100
101	101
*DB2:*
0	" "
1	" "
2	" "
...
10	" "
11	" "
...
100	" "
101	" "
=====

Query:SELECT intkey, RIGHT(intkey, 2) FROM table ORDER BY intkey
*SQLServer, Sybase, Ingress, MySQL, Teradata (this result is OK):*
0	0
1	1
...
10	10
11	11
...
100	00
101	01
*Oracle:*
0	<null>
1	<null>
2	<null>
...
10	10
11	11
...
100	00
101	01
*Postgres:*
0	0
1	1
2	2
...
10	10
11	11
...
100	100
101	101
*DB2:*
0	"  "
1	"  "
2	"  "
...
10	"  "
11	"  "
...
100	"  "
101	"  "