>>>I am trying to do a [replace all] for cField = ***** (Numeric overflow) but I get a error cause ***** has no quotes and isn't a number
>>

>>... for cField>val(replicate('9',fsize('cField')))
>>

>>bye
>
>This wont work if the field has decimals, ie N(10,3)

You're right.

>

>PROCEDURE maxval
>LPARAMETERS size, dec
>LOCAL cNum
>cNum = REPLICATE('9', dec)
>cNum = "." + m.cNum
>cNum = REPLICATE('9', m.Size - (m.dec + 1)) + m.cNum
>RETURN VAL(m.cNum)
>

Since size and dec must be passed as arguments to the function, this is hardly a general approach. In fact, knowing that information, it would be simpler to hardcode the value in the scope expression (like Caroline suggested).

Strangely, VFP seems to not have a function to give you the precision of a numeric field, or am I missing something?

bye