<div>
select * from some_table <br />
where someresulttype &gt;= 11.0
</div>


<div>
Error converting data type varchar to numeric
</div>


<div>
Oh.... (11.0) &nbsp;it's Decimal.... Cast it into DECIMAL<br />
<br />
select * from some_table <br />
where CAST(someresulttype &nbsp;as decimal) &gt;= 11.0<br />

</div>


<div>
what are the values of &quot;someresulttype&quot;, please?
</div>


<div>
With decimal &nbsp;I get the same problem: <br />
<br />
Error converting data type varchar to numeric<br />
The resulttype values look like all numbers but I'm guessing there could be a character in the values somewhere. Maybe a &lt;&nbsp;or &gt;&nbsp;then sign since they are medical results for lab tests. Thanks
</div>


<div>
does your data in the column contain &quot;,&quot; or &quot;.&quot;, or both? spaces in the middle? thousand separators?<br />
please check.
</div>


<div>
I've double checked and did do a Replace to get rid of the &gt;&nbsp;then sign. Now it is just decimal numbers and NULL's. Still get the same error trying to convert though. 
</div>


<div>
again: can you show sample data of the field, please?
</div>


<div>
Ok, I found that some idiot wrote in &quot;high&quot; so I'm not sure how to go about dealing with that. Should I somehow do a Replace so that it comes back with a number? 
</div>


<div>
this should do:<br />

<pre><code class="code-1 nolinks" id="code-125073"><span>select * from some_table</span>
<span>where cast(case when isnumeric(someresulttype) = 0 then NULL else someresulttype end as numeric(10,2)) &gt;= 11.0</span>
</code></pre>
</div>


<div>
angellll that works. Thanks a ton. However, what does the numeric(10,2) do and how did you get around the fact that there was a field in the column with text? 
</div>


<div>
Actually now this creates a problem in trying to run my SQL report as it can not compare either blanks or NULLS's. This simple query in VB for SRSS throws an error, however when only comparing numbers it works fine. <br />
=SUM(Iif(Fields!hga1c.Valu<wbr />e=&quot;&quot; or Fields!hga1c.Value=&quot;NULL&quot;,<wbr />1,0),&quot;Pers<wbr />onStats&quot;)<br />
<br />

</div>


<div>
<div class="content wysiwyg-content">
I run a query such as :<br />
select * from some_table <br />
where someresulttype &gt;='11.0'<br />
and I get far more returned back then I should. I look at the someresulttype column and get many numbers that are less then the 11.0. When I try to do a CAST(someresulttype as int)&gt;= '11.0'<br />
I get:<br />
<br />
Conversion failed when converting the varchar value '11.0' to data type int
</div>
</div>


I run a query such as :
select * from some_table 
where someresulttype >='11.0'
and I get far more returned back then I should. I look at the someresulttype column and get many numbers that are less then the 11.0. When I try to do a CAST(someresulttype as int)>= '11.0'
I get:

Conversion failed when converting the varchar value '11.0' to data type int

Problem casting or converting varchar to int

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.