On Thu, 11 Apr 2013 09:35:44 -0000, "wan30032" <wan30032@...> wrote:

> in addition:
>
> how to show as int from block or procedure?
>
>
>
> SET TERM !;
> EXECUTE BLOCK
> RETURNS (IID INT,I1 INT)
> AS
>
> BEGIN
> SELECT IID,I1 FROM T1 WHERE IID=7000000 INTO :IID,:I1;
> SUSPEND;
> END
> !
> SET TERM ;!

Try ASCII_VAL
http://www.firebirdsql.org/file/documentation/reference_manuals/reference_material/html/langrefupd25-intfunc-ascii_val.html

Mark