Subject Zeropadding integer columns?
Author Markus Lervik

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?

Markus Lervik

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