How do I separte Text from the fpost code SW1, S20 and ... ans

[Passage]

How do I separate the Text from the first two Characters of the post code
i.e. for SW1 1KP, answer should be SW and for S20 1PU answer should be S.
Help in access or sql

 

[Ken Snell [MVP]]

see reply in other newsgroup where you posted this question.