How do I extract the first alphabetical characters from a postcode column?
For example say my table contains the following data (note: it's alphanumeric and the numbers can start on the 2 or 3 digit):
AB123DF D546WQ3 FG2341F DE33444 H765431
How do I query it to return:
AB D FG DE H
Basically the first 2 characters need to be returned but any numbers in that returned set are truncated/trimmed from the result so only alphabetical ones show. Is this possible?