You can't as Integers, as they aren't integers ..
Use Varchar and pad them out yourself.


Best regards,
Fred Wilson
SE, Böwe Bell + Howell
fred.wilson@...




-----Original Message-----
From: Ronaldo Rezende Vilela Luiz [mailto:ronaldinho79@...]
Sent: Wednesday, December 10, 2003 10:30 AM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] zero's on the left side


How can I store integer numbers with 5 digits and 0 on the left side?

for example:

0 -> 00000
1 -> 00001
11 -> 00011
333 -> 00333
4444 -> 04444



Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/SIG=12cd9itgt/M=258297.4271147.5470572.4049140/D=egroup
web/S=1705115386:HM/EXP=1071164635/A=1683962/R=0/*http://www.techsmith.com/r
dr/ban/syah/default.asp> click here

<http://us.adserver.yahoo.com/l?M=258297.4271147.5470572.4049140/D=egroupmai
l/S=:HM/A=1683962/rand=952453466>

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



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .