Query column for values withut numbers?

[chris-uk-lad]

Hi,

I have a column that contains some values with just characters, and some with a mix of characters and numbers. I want to split the 2 but the method i thought would fix it, doesnt :x

not like ([*1234567890*])

Thanks for the assist

 

[namliam]

What you are thinking of is a regular expresion, which is the hard way of doing this.

The easy way is...
Not like "*#*"

Good luck

 

[chris-uk-lad]

that worked great, thank you