Dear All,

I have simple question need helped :

I have a table with data :

AA00,BB01,CC00,DD02

I want the data sort by substring from the third char, so the data
will appear : 00,00,01,02.

If I use SQL on oracle, I can use the syntax :

SELECT SUBSTR(column,2,2) FROM TABLE1

How the syntax can I use with firebird ?

Thanx,
MONALISA.