This questions references my past questions here: http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_21813695.html
The solution from this past question works great until I run across negative amounts in the varchar field. Then I get the same cannot convert varchar to money error.
Here's the convert I use:
,'*', '') as money) / 100,1)
So when data looks like this: 3487*0*0 it works fine. When it looks like this: -3487*0*0 it doesn't convert.
How do I fix this?