FW: AW: Formating a number

Hello. Thank you very much for response Elke.

I wanted that when I had a number of one digit, this changed to two digits 
by to add a 0 in front of that number of one digit.

I think that I explained bad my problem.

I resolved using the CASE statement.

Regards.

>From: "Zabach, Elke" <elke.zabach@xxxxxxx>
>To: 'David Pérez Gómez' <galvi77@xxxxxxxxxxx>
>Subject: AW: Formating a number
>Date: Thu, 18 Nov 2004 11:18:16 +0100
>
>Hi,
>
>What do you expect in these cases?
>
>Number      format (number, "00")
>
>-123
>-100
>-070
>-021
>-007
>000
>007
>021             21
>070
>100
>123
>
>Elke
>SAP Labs Berlin
>
>
> > -----Ursprüngliche Nachricht-----
> > Von: David Pérez Gómez [mailto:galvi77@xxxxxxxxxxx]
> > Gesendet: Mittwoch, 17. November 2004 19:09
> > An: maxdb@xxxxxxxxxxxxxxx
> > Betreff: Formating a number
> >
> > Hello.
> >
> > I have a problem:
> >
> > I must give format to a number that has 3 digits and must leave it 
in 2
> > digits.  For example, if the number is 021, it would have to 
remain in 21.
> > It is for including in a query.
> >
> > In ACCESS a way exists that is: format(number, "00").
> >
> > Is there any way to do than in MaxDB?
> >
> > Thank you in advance.
> >
> > _________________________________________________________________
> > La información más fresca desde diferentes puntos de vista en la 
Revista
> > de
> > Prensa de MSN. http://es.newsbot.msn.com/
> >
> >
> > --
> > MaxDB Discussion Mailing List
> > For list archives: http://lists.mysql.com/maxdb
> > To unsubscribe:    
http://lists.mysql.com/maxdb?unsub=elke.zabach@xxxxxxx

_________________________________________________________________
Acepta el reto MSN Premium: Protección para tus hijos en internet. 
Descárgalo y pruébalo 2 meses gratis. 
http://join.msn.com?XAPID=1697&DI=1055&HL=Footer_mailsenviados_proteccioninfantil


--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/maxdb?unsub=gcdm-maxdb@xxxxxxxxxxx