Alex,
I believe you should be able to do this:
SELECT 00000.00 as newField FROM ...
HTH,
Chad
>Is there a way to create a SQL Server remote view with an empty (zero) decimal field with specified precision and scale. I believe it can be done with CAST(0 AS NUMERIC(8,2)) in VFP9, but how about VFP8?
>
>TIA,
>
>Alex
_________________________________
There are 2 types of people in the world:
