Not quite clear, what do you mean, "correct". Do you wish to change the table field structure, or youi do not want to insert the value if its length does not feet the field width?

In any event you need to compare the data length with the field width and to take the appropriate action.

Say, you have the data and field width:
lndata=1000
lnfldwidth = 3

if val(replicate("9",lnfldwidth))>=lndata
* OK, continue
else
* error
endif




>yes.
>J want detect error and correct before that fields become *******
>
>gerry