Jean-Michel OLTRA wrote:
>
> bonjour,
>
> Is there a way, with MaxDB functions, to convert string into integer:
> As un example:
>
> sqlcli=> SELECT CHR(NUM(1)+1) FROM DUAL
> | EXPRESSION1 |
> | ----------- |
> | 2 |
> 1 row selected (3 msec)
>
> sqlcli TROUPEAU=> SELECT CHR(NUM('1')+1) FROM DUAL
> | EXPRESSION1 |
> | -------------------------------------------- |
> | 2.0000000000000000000000000000000000000E+00 |
> 1 row selected (7 msec)
>
> I would like the first behavior with a 'numeric string', as in the
> second example.
>
> thanks,
>
NUM(number) is of no use.
Try CHR ( FLOAT(1, n) + 1) FROM DUAL
with n being a number between 1 and 38 according to your needs.
Elke
SAP Labs Berlin
> --
> jm
>
>
> --
> MaxDB Discussion Mailing List
> For list archives: http://lists.mysql.com/maxdb
> To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]
>
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
