Rick Schummer wrote: >>> But why do I get 0.00 in the first query? Just curious.<< > > My recommendation is to run the queries in Management Studio and see the > data types selected by SQL Server.
I did run it in the Studio, and got the same results. It seems to be a VFP vs MSSQL Back-end issue. I don't know how to see what the data type is, but that will be a good exercise for the student. Luckily, it's no longer a critical issue, now that we're aware of it. Thanks. _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
