I am getting an error "Error converting data type varchar to numeric"

Select CONCAT('$', '        ', a * 0.05 + b * 12) As value

Variables a and b are having money Data type

>Solution :

Try casting the arithmetic expression to text before including it as a parameter in the CONCAT() function:

SELECT CONCAT('$', ' ', CAST(a * 0.05 + b * 12 AS varchar(20))) AS value;