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 >