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 :confused:

cheers
Jim

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

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...