<div>
try<br />
<br />
&quot;&nbsp;select bla bla bla...... where &nbsp;CONVERT(VARCHAR(20), Price) &nbsp;&quot; like '%&quot; &amp;&nbsp;Request.form(&quot;selectvalue&quot;<wbr />) &amp;&nbsp;&quot;%'&quot; &nbsp;<br />

</div>


try

" select bla bla bla...... where  CONVERT(VARCHAR(20), Price)  " like '%" & Request.form("selectvalue") & "%'"  


<div>
the slight differences between the two syntaxes<br />
<br />
- &lt;BOL&gt;CAST is based on the SQL-92 standard and is preferred over CONVERT.&lt;/BOL&gt;<br />
- Casting money datatype to varchar uses varchar(30) as default target datatype
</div>


the slight differences between the two syntaxes

- <BOL>CAST is based on the SQL-92 standard and is preferred over CONVERT.</BOL>
- Casting money datatype to varchar uses varchar(30) as default target datatype

<div>
<div class="content wysiwyg-content">
hi<br />
<br />
i have the following sql statement<br />
&quot;&nbsp;select bla bla bla...... where &nbsp;Price &nbsp;&quot; like '%&quot; &amp;&nbsp;Request.form(&quot;selectvalue&quot;<wbr />) &amp;&nbsp;&quot;%'&quot; &nbsp;<br />
<br />
This sql statement works Ok in ACCESS but in SQL 2000 i get the following error<br />
<br />
Microsoft OLE DB Provider for ODBC Drivers error '80040e14' <br />
<br />
[Microsoft][ODBC SQL Server Driver][SQL Server]Implicit conversion from data type money to varchar is not allowed. Use the CONVERT function to run this query. <br />
<br />
Any idea how to fix that ?<br />
Thx<br />

</div>
</div>


hi

i have the following sql statement
" select bla bla bla...... where  Price  " like '%" & Request.form("selectvalue") & "%'"  

This sql statement works Ok in ACCESS but in SQL 2000 i get the following error

Microsoft OLE DB Provider for ODBC Drivers error '80040e14' 

[Microsoft][ODBC SQL Server Driver][SQL Server]Implicit conversion from data type money to varchar is not allowed. Use the CONVERT function to run this query. 

Any idea how to fix that ?
Thx


Using LIKE in SQL to compare Money type field to a string

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.