Hi!
I want get sum of to varchar number.
declare @sum char(9) = '33,87', @sm char(9) = '55,83' select REPLACE((Convert(MONEY, @sum) + Convert(MONEY, @sm )),',','.')
Result: 89.7
Hi PRA,
Refer below query.
SQL
DECLARE @sum CHAR(9) = '33,87', @sm CHAR(9) = '55,83' SELECT CONVERT(MONEY,REPLACE(@sum,',','.')) + CONVERT(MONEY,REPLACE(@sm,',','.'))
Output
89.70
© COPYRIGHT 2025 ASPSnippets.com ALL RIGHTS RESERVED.