Select SQL Non numeric Values
<p>I need to select just the rows within a sql table which contain no numerical values whatsoever, here's an example table:</p>

<pre><code>AddressLine1
-------------
59 Prospect Road
Rose House
24 St. Pauls Place
1 Oxford Avenue
9 Stonecross Road
65 Wood Common
19 Falcon Close
Thorn House
16 Poplars Close
52 Coombes Road
12 Brinsmead
14 Meadow Close
15 Rowlatt Drive
</code></pre>

<p>In this example I would just be looking for "Rose House" and "Thorn House" rows to be returned.</p>

<p>Any suggestion on the code I should be using would be gratefully received.</p>