<div>
declare @x varchar, @y money <br />
select @y =123900.00<br />
select @x = convert( varchar(100), @y)
</div>


declare @x varchar, @y money
select @y =123900.00
select @x = convert( varchar(100), @y)

<div>
@dawes4000<br />
<br />
If you were using cfqueryparam you wouldn't have to worry about this kind of problem ;-)
</div>


@dawes4000

If you were using cfqueryparam you wouldn't have to worry about this kind of problem ;-)

<div>
... I think I submitted that last comment via &quot;SUBMIT&quot; and not &quot;OBJECT&quot;. &nbsp; But in case I didn't, to any mods: &nbsp;No, I don't have any objection :)
</div>


... I think I submitted that last comment via "SUBMIT" and not "OBJECT".   But in case I didn't, to any mods:  No, I don't have any objection :)

<div>
<div class="content wysiwyg-content">
I need to convert varchar to money data type when doing a SQL insert. I'm using sql server 2000. Below is my insert statement.<br />
INSERT INTO mast<br />
(custno, sodate, ordate, disc, taxrate, tax, ordamt, authamt, ponum, salesmn, sostat, sono, defloc, finalized, adddatetime) VALUES &nbsp; &nbsp; ('#qrymast.custno#','#qrym<wbr />ast.sodate<wbr />#','#qryma<wbr />st.ordate#<wbr />','#qrymas<wbr />t.disc#','<wbr />0','0','#q<wbr />rymast.ord<wbr />amt#','0',<wbr />'#qrymast.<wbr />ponum#','#<wbr />qrymast.sa<wbr />lesmn#','#<wbr />arguments.<wbr />status#','<wbr />#qrymast.s<wbr />ono#','#de<wbr />floc#','#f<wbr />inalized#'<wbr />,'#qrymast<wbr />.adddateti<wbr />me#')<br />
<br />
The Insert fails on taxrate, tax, ordamt. I have tried the CONVERT function but have not been able to get it to work, and have left my attempts out of this post only to keep it brief.<br />

</div>
</div>


I need to convert varchar to money data type when doing a SQL insert. I'm using sql server 2000. Below is my insert statement.
INSERT INTO mast
(custno, sodate, ordate, disc, taxrate, tax, ordamt, authamt, ponum, salesmn, sostat, sono, defloc, finalized, adddatetime) VALUES     ('#qrymast.custno#','#qrymast.sodate#','#qrymast.ordate#','#qrymast.disc#','0','0','#qrymast.ordamt#','0','#qrymast.ponum#','#qrymast.salesmn#','#arguments.status#','#qrymast.sono#','#defloc#','#finalized#','#qrymast.adddatetime#')

The Insert fails on taxrate, tax, ordamt. I have tried the CONVERT function but have not been able to get it to work, and have left my attempts out of this post only to keep it brief.


How to convert varchar to money on sql insert

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

ColdFusion is a server-side rapid application development platform originally created by Allaire and now sold by Adobe, implementing the dynamic general purpose CFML programming language. The term ColdFusion is sometimes colloquially used to refer to the CFML language (Cold Fusion Markup Language), but can also include discussions of the server software implementation. ColdFusion runs using a customised version of Apache Tomcat. Earlier versions are bundled with JRun.