mattkovo
asked on
Convert to money SQL
I have a value of ($6.53) that I need to convert to money. The () is messing up the following syntax so I need to know how to work around it.
convert(money, sales)
Any help here?
convert(money, sales)
Any help here?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
select convert(money, ABS(sales))
probably the value ($6.53) is shown here should be a negative number and try using ABS function to negate it
probably the value ($6.53) is shown here should be a negative number and try using ABS function to negate it
SELECT CONVERT (MONEY,REPLACE(REPLACE(Sal