Find first non numeric character in string
I want to strip out the first part of a string so that the result starts with
the first non numeric character. The second numeric value (19184 in the
example below) is an id that can vary in length so I can't just use the mid
function as the starting point will vary.
Example:
"1 - 19184 - BP Trowbridge Lodge Service Station"
I want to return "BP Trowbridge Lodge Service Station"
Thanks for any help
|