Converting varchar to money
<pre><code>CREATE TABLE [dbo].[tblBSP](
    [OS_PESO] [varchar](100) NULL
) ON [PRIMARY]
GO
</code></pre>

<p>I have this table name <code>tblBSP</code> with a column <code>OS_PESO</code>. Now, I have to <code>BULK INSERT</code> values for <code>OS_PESO</code>. Values for <code>OS_PESO</code> column would be something like this:</p>

<pre class="lang-none prettyprint-override"><code>58,083.15 
2,000,000.00 
(2,004.84)
</code></pre>

<p>I have the following error:</p>

<blockquote>
  <p>Cannot convert a char value to money. The char value has incorrect syntax.</p>
</blockquote>

<p>I've seen questions that are similar to these hence, I've tried these, but it doesn't seem to work. </p>

<pre><code>update tblBSP
set OS_PESO = (select convert(money,replace(OS_PESO,',','')))

--or 

update tblBSP
set OS_PESO = (select CAST(isnull(OS_PESO,0) as money))

--or

update tblBSP
set OS_PESO = (SELECT CONVERT(varchar, CONVERT(money, OS_PESO), 1 ))
</code></pre>

<p>Thanks. ^^</p>