>>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