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