How to use the LEFT function to extract just characters

Hello,

I need to know a way to extract just the first letters of a post code. I am fine using LEFT, I use it all the time with LEN and FIND amongst other things, but normally it is just to find the first space before extracting a string.

However I need to know how to get the LEFT function to know when it moves past characters and for it to stop as soon as it finds a digit.

Post COdes in the data I have will be normal UK standard, so could be two characters before the digits or a single character before the digits....

CB8 or S4.

Howe can I extact just the single or double characters and not the digits?

Regards

Ah yes, MIN. Totally forgotten about that one. Used it once many moons ago.

That will do the trick nicely.

Thanks