> 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
> 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?

no,...
0049149 is not an integer

but you can select the padded result any time you want it using UDF's

Alan