This content has been marked as final. Show 4 replies
I am looking to trim a field storing postcodes, the issue im having is that i dont want to specify the trim to a set number of characters as some first parts of a post code can be 2,3 or 4 characters long.
Is it possilbe to trim until it reaches a space, so for example
B1 2AA = B1
B12 3AA = B12
BE12 4BB = BE12
Any help would be greatly apreciated...