>>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?
>
>Alex,
>
>The query for remote view is executed on backend (SQL Server) so it should use T-SQL syntax not VFP.

Thanks for the explanation.

Alex