>>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
>
>
>select .....,CAST(0 AS DECIMAL(6,2)) fieldName ..... FROM ...
>
Thank you,
Alex