Hi,

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?


Regards,
Markus Lervik

--
Markus Lervik /"\ ASCII Ribbon Campaign
Digital Diversity Studios \ / Against HTML Mail,
http://www.digitaldiversity.info X HTML News too, and
info@... / \ MS WORD docs.
++