从字符串返回以特定后缀结尾的单词(Returning word from string which ends in specific suffix)

 我需要在SQL Server（2014）中以特定后缀结尾的列中返回一个单词 
 
 在这种情况下“简历” 
 
 示例：垫圈T1 11CV金EA 
 来自子串的期望结果：11CV 
 
 我知道我将不得不使用像Substrings和Charindexes这样的东西。 
 
 这是我到目前为止： 
 
   SUBSTRING(PartDescription, 1 ,CHARINDEX('CV', PartDescription)+1)  AS [CV]
 
 但它只返回字符串直到我想要的后缀。 
 示例：“Washer T1 11CV” 
 
 理想情况下，我只想返回有问题的单词。 
 
 任何帮助将非常感激 

I need to return a word in a column which ends in a specific suffix in SQL Server (2014)
 
In this case "CV"
 
Example: Washer T1 11CV Gold EA
 Desired outcome from substring: 11CV
 
I know I will have to use something like this involving Substrings and Charindexes.
 
This is what I have so far: 
 
   SUBSTRING(PartDescription, 1 ,CHARINDEX('CV', PartDescription)+1)  AS [CV]
 
But it only returns the string up until the suffix I want.
 Example: "Washer T1 11CV" 
 
Ideally I just want to return the word in question.
 
Any help would be much appreciated

原文：https://stackoverflow.com/questions/43218862