Oscar,

Try

select field1, field2, ..., 000.00000000 as MyNumericField ...

HTH
>I need to prepare a cursor column as n (12, 8)
>
>I’m trying:
>
> select field1, field2, ..., val(“000.00000000”) as MyNumericField ...
>
>
>but I’m getting a numeric with format n(15,2) for MyNumericField
>
>Could somebody give a hint in order to get the numeric field as n(12,8)?
>
>Thanks in advance and regards.
>
>
>Oscar Corte