Hi all,
Am using remote views to connect via ODBC to Oracle and Sql servers. For numeric data types in VFP, say 18 digits with 6 decimal points, what is the equivalent field types in Oracle and Sql servers?

I'm trying to standardize to use only 1 type of remote view instead of 1 for Oracle and 1 for SQL server. Oracle offers the number data type while SQL server has money, numeric, float, decimal. If I want to have the equivalent of 18 digits and 6 decimal points in remote view, what data type is best for Sql server? If numeric is chosen, would the same remote view be able to access the number data type in Oracle?

Thanks in advance
Yau