Subject RE: [firebird-support] Zeropadding integer columns?
Author Alan McDonald
> Is there any way to zero pad an integer column in Firebird?
> Ie, adding 0049149 wouldn't 'truncate' it to 49149?
> I've been googling and scanning through the manuals and searching
>'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