>
STR(m.nNumber, LEN(STR(m.nNumber)), LEN(STR(m.nNumber)))
is equivalent to
STR(m.nNumber, 10, 10)
>
>Thus, your (or Microsoft's) solution is obviously wrong. Your function RoundEx(123456.123456, 5) will give you an incorrect result 123456.12300.
Ben,
thank you.
Excellent solution.
Do you have an idea why this MS KB article describes totally wrong solution ?
This KB article is written in 2003.
Totally wrong solution has been present for 4 years!
Andrus