thx it works again!

but when it comes to INTEGER or SMALLINT type, it won't work again.
for example,

ii INTEGER Not Null;
si SMALLINT Not Null;
set width ii 4;
set width si 2;
select ii, si from test;
ii si
========== =======
1001 1

ii and si displays 10 chars and 7 chars.
I want them to be 4 chars and 2 chars like
ii si
==== ==
1001 1

is this again possible?

thx a lot
HR

--- In firebird-support@yahoogroups.com, Norman Dunbar <Norman@...> wrote:
>
> Sorry typo,
>
> Set width LFN 10;
> select long_field_name LFN from test; // => display 10 chars
>
> Cheers,
> Norm.
>
> --
> Norman Dunbar
> Dunbar IT Consultants Ltd
>
> Registered address:
> Thorpe House
> 61 Richardshaw Lane
> Pudsey
> West Yorkshire
> United Kingdom
> LS28 7EL
>
> Company Number: 05132767
>