> So I want to change 1->a, 2->b ...
> How to do it?

If you are using firebird 1.5 you can use CASE

eg.

SELECT
case
when row = 1 then 'a'
when row = 2 then 'b'
else 'c'
end as letter
from table

HTH
Gary