>Gregory
>
>Thank you for the explanation. I would have been many hours arriving at that conclusion! If at all. The curious thing is that it has been working fine for several months. Maybe by chance the resulting figure format has agreed with the view so far and this has come about on one particular record.
>
>Anyway, sorted. And thanks again for your input. Much appreciated.
>
>Barry.

Make it a rule to always use CAST for calculated fields. Don't rely on VFP (or any other backend) to make correct assumptions about the final field type.