>Hi!
>
>
CREATE TABLE t ( t numeric(8,5))
>INSERT INTO t VALUES ( 1000 )
>?TRANSFORM(t)
>
>
>outputs
>
>**.*****
>
>How to get real field value as string ?
alltrim(str(t))
You can also copy the value into a variable or a property of a scatter object and use transform() on that. It seems that the 2nd parameter of transform() defaults to "99.99999" for a n(8,5) field. No field, no strict default.