You can use a UDF to do that without changing the column to char...

Try out rFunc @ sourceforge

Michael Olschimke

-----Original Message-----
From: Markus Lervik [mailto:markus@...]
Sent: Mittwoch, 13. August 2003 06:46
To: firebird-support@egroups.com
Subject: [firebird-support] Zeropadding integer columns?



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.
++



To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/