HI

I am trying to find the last letter within a string.

I have a field which contains data like CV8 7TY0124 121212

I am trying to extract everything prior to the first letter, ie CV8 7TY

I am thinking about finding the last letter within a string, then using the right, left or Mid funtion to grab the characters I want. Am I on the right lines?

Would appreciate any help