|RE: [firebird-support] Zeropadding integer columns?
> Is there any way to zero pad an integer column in Firebird?no,...
> Ie, adding 0049149 wouldn't 'truncate' it to 49149?
> I've been googling and scanning through the manuals and searching
> IBPhoenix.com's Knowledge Base, but I still haven't found anything.
> Is the only way to do this to make the column a CHAR or VARCHAR?
0049149 is not an integer
but you can select the padded result any time you want it using UDF's