Michael L John - Friday, September 22, 2017 9:54 AM
Jeff Moden - Thursday, September 21, 2017 11:42 PM
crow1969 - Thursday, September 21, 2017 9:34 AM
I would guess the conversion routine simply drops all thousands separators, and then converts to a numeric type: declare @var money set @var = ',1,00,00.99' select @var
Z'actly.
Just like this SELECT CONVERT(int, '') Equals 0 ???
Heh... Z'actly again! 😉
Nothing = Nothing... Null is not Nothing. 😉
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row. First step towards the paradigm shift of writing Set Based code: ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.