selecting fields without numbers

[JimmyS]

Quick question -

I have a set of data that goes A1, AS, A2, A6, BM, B2, GF, T3, 1B, 3G, etc...

I would like to select only the fields where there are no numbers - so from the above set it would be AS, BM and GF.

Can't quite suss it

cheers
Jim

 

[Mile-O]

Wouldn't a normalised structure be more beneficial and give you the flexibility you require?

 

[JimmyS]

if only it were my data table - then I might try to work out what this normalisation lark is all about

Unfortunately that is how these codes are set in the source data - from another system - and I need to extract a certain few lines to append to another table...