Extract only numbers from a varchar column

------=_Part_19753_18722956.1210007336095
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

I need to extract only the first occurence of numbers from a column  that
is
varchar.

Here are a few examples of what I need to do:

abc200xx -> 200
340ppsdd -> 340
150ytyty555 -> 150

Can this be done by a simple query or do I need to use a cursor?

Thanks

------=_Part_19753_18722956.1210007336095
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

<p>I need to extract only the first occurence of numbers from a column
&nbsp;that is varchar.</p><p>Here are a few examples of what I need to
do:</p><p>abc200xx -&gt; 200<br>340ppsdd -&gt; 340<br>150ytyty555 -&gt;
150<br></p><p>
Can this be done by a simple query or do I need to use a
cursor?</p><p>Thanks</p>

------=_Part_19753_18722956.1210007336095--