return only records containing non-numeric characters

[lucasm]

I'm trying to weed out certain records returned from a query, eliminating the ones where the "name" varchar field contains a number - here's an example:

1103 TS - Crew
1203 TS - Crew
Adamski
Allanbrook
Allen
Standard TS - Div 20

I want the first two and the last one to be ignored.

 

[SQLBill]

WHERE [name] NOT LIKE '%[0-9]%'

Refer to the BOL for more information on WILDCARDS. Look up LIKE.

-SQLBill

Posting advice: FAQ481-4875

 

[lucasm]

thanks, that worked a treat!