<div>
ive just tried:<br />

<pre><code id="code-20-41787404-1">use Dictionary
select word
from TblWords
where word is not null and word not like'%[0-9]'
group by word
order by word</code></pre>
<br />
thats giving me where there is mixture of alpha numeric.<br />
<br />
thats one part done<br />
<br />
the alpha characters only i cannot word out can i do A-z ?
</div>


ive just tried:


use Dictionary
select word
from TblWords
where word is not null and word not like'%[0-9]'
group by word
order by word


thats giving me where there is mixture of alpha numeric.

thats one part done

the alpha characters only i cannot word out can i do A-z ?

<div>
and failed with this:<br />

<pre><code id="code-20-41787407-1">use Dictionary
select word
from TblWords
where word is not null and word like'[A-Z][a-z]'
group by word
order by word</code></pre>
</div>


and failed with this:


use Dictionary
select word
from TblWords
where word is not null and word like'[A-Z][a-z]'
group by word
order by word

<div>
<div class="content wysiwyg-content">
I am not sure how to create an sql server query that will return the strings that have no numeric characters in them and then another that has ability to return mixed i.e A'4'.<br />
<br />
The field word only holds one word.<br />
<br />
so:<br />
'0'<br />
'001001101'<br />
'F1'<br />
'1f'<br />
&nbsp;would not be returned<br />
<br />
words :<br />
<br />
'sweeper'<br />
'bhp'<br />
<br />
would be returned the field name is word from Tblwords
</div>
</div>


I am not sure how to create an sql server query that will return the strings that have no numeric characters in them and then another that has ability to return mixed i.e A'4'.

The field word only holds one word.

so:
'0'
'001001101'
'F1'
'1f'
 would not be returned

words :

'sweeper'
'bhp'

would be returned the field name is word from Tblwords

sql server query

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.