I want to query formula from column of database.
SET AmountBasedOn = CAST(B.SalaryFormulaValue AS money) * -1
FROM THMSALARY AS A
INNER JOIN TDMSALARY AS B
ON A.Oid = B.HeaderSalaryID
WHERE SalaryFormula LIKE '%UMT%'
Msg 235, Level 16, State 0, Line 6
Cannot convert a char value to money. The char value has incorrect syntax.
How could I do it ?