Casting String to Money Value in SQL Server
35,447
This should do the trick
SELECT '$1,000.00'
,CAST('$1,000.00' AS MONEY)
,CAST(REPLACE(REPLACE('($1,000.00)', '(', '-'), ')','') AS MONEY)
And per @mellamokb's suggestion, if you're using SQL 2012, you can use this:
SELECT PARSE('($1000.00)' AS MONEY)
Author by
Cavyn VonDeylen
Graduated from the Milwaukee School of Engineering in 2012 with a degree in Software Engineering. Currently on the Microsoft Defender team.
Updated on May 15, 2020Comments
-
Cavyn VonDeylen almost 4 years
Is there a simple built-in way of converting NVARCHARs in the format "$1,000.00" and "($1,000.00)" to the numerical values 1000.00 and -1000.00 respectively?
I'm trying to do this in either SQL Server or SSIS.
Casting to MONEY gives me the error
"Cannot convert a char value to money. The char value has incorrect syntax.".
when attempting to cast the negative value, I'm assuming due to the parenthesis.