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