How to make this sql query? 2

[7Star]

Hi,

I was wondering if anyone could help me do the following query in sql:

In my database I have a column, PNR, that stores values in the with the format XXXXX-XXXX, where X can be either a numerical value or a letter. The data I want to get from the column PNR is records that does have one or more letter. For example if I have the following records:

247883-1111
324233-2331
123213-2344
71020B-4995

Then I just want the 71020B-4995 record. Anyone have some ideas howto make a query like this?
/ Ola

 

[SQLDenis]

select * from table where pnr like '%[a-z]%'

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[vongrunt]

select ...
from myTable
where myColumn [!]like '%[A-Z]%'[/!]

------
Theory: everybody knows everything, nothing works
Practice: everything works, nobody knows why

 

[7Star]

Oh, it wasnt harder than that?
Thanks a lot, both of you