MS SQL ROUND() vs. VB ROUND()

I have found that ROUND() command are different among MS products (VB, SQL,
Excel, VBA, etc) in versions like (Banker's Rounding, Random Rounding,
Rounding Up, Rounding Down, etc.)
In my Apps, I use VB6 and MSSQL 2000, arithmetic operations were done in
both plataforms (not crazy way until I notice this...). THAT IS THE PROBLEM.
SOLUTIONS:(Please advise me)
1. Use only one plataform for arithmetic operations (Best).
2. Create a function that invoke a SP which returns ROUND() from SQL (Does
it decrease or impact performance?)
3. Other

Beforehand, thank you very much.

--
Luis Garcia
IT Consultant


"LUIS" wrote:

>
> --
> Luis Garcia
> IT Consultant