convert nvarchar to money
I've looked in Transact-SQL help and searched P2P but can't see that I can convert an nvarchar column to money type. My goal is, to take numbers and format them with a comma as thousands separator. The nvarchar column contains numbers that were converted to nvarchar for another reason, and now I want them back as numbers.
When I do this:
case when columnx='.00' then '' else convert(money,columnx,1) end
I get an error saying that an implicit conversion is not allowed and I must use the convert function. ????
I'm using money,1 because I think that style allows for a comma as thousands separator, but I got it from Help in the context of changing FROM money TO nvarchar, the other way 'round from what I want to do.