SQL Server - 获取字符串的不同部分

Let me start off by saying this is for a database view that I do not manage so the data is what it is. It has a column for job title which also includes the job level (e.g. Software Engineer 2, Designer C, Air Traffic Controller E-1, etc...) I need to get the distinct job titles. All the Software Engineers (level 1 through 6) should return a single value. Job titles can have one or more words in them. Levels can have 1 to 3 characters. I tried this to get the levelLet me start off by saying this is for a databa