or you can store them as integers and pad them on the select (way out)
Alan

> -----Original Message-----
> From: Ronaldo Rezende Vilela Luiz [mailto:ronaldinho79@...]
> Sent: Thursday, 11 December 2003 4: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
>
>
>
> 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/
>
>
>
>