<div>
you can use isnumeric(field)
</div>


<div>
<a href="http://msdn2.microsoft.com/en-us/library/ms186272.aspx" rel="ugc">http://msdn2.microsoft.com/en-us/library/ms186272.aspx</a>
</div>


http://msdn2.microsoft.com/en-us/library/ms186272.aspx [http://msdn2.microsoft.com/en-us/library/ms186272.aspx]

<div>
Sorry Atlanta Mike. I missed that your answer was first. I will add a new Questions named Points for Atlanta_Mike 
</div>


Sorry Atlanta Mike. I missed that your answer was first. I will add a new Questions named Points for Atlanta_Mike

<div>
Thanks... thought that was funny.
</div>


<div>
If i didnt have missed &nbsp;your message I would have saved 30 sec to find out that I have to use = 1
</div>


If i didnt have missed  your message I would have saved 30 sec to find out that I have to use = 1

<div>
You have it here now mike<br />
<br />
<a href="https://www.experts-exchange.com/questions/21855242/points-for-Atlanta-Mike.html#16708811" rel="ugc nofollow">https://www.experts-exchange.com/questions/21855242/points-for-Atlanta-Mike.html#16708811</a>
</div>


You have it here now mike

https://www.experts-exchange.com/questions/21855242/points-for-Atlanta-Mike.html#16708811 [https://www.experts-exchange.com/questions/21855242/points-for-Atlanta-Mike.html#16708811]

<div>
<div class="content wysiwyg-content">
I have a varchar field that can contains values like<br />
<br />
ABC<br />
01235<br />
CD2451<br />
<br />
I like to delete everything that has only numbers. How can I do that?
</div>
</div>


I have a varchar field that can contains values like

ABC
01235
CD2451

I like to delete everything that has only numbers. How can I do that?

Help with delete statement

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.