如何从sql中的字符串中获取特定的字母

如果其他字符串也有类似的模式,则可以执行以下操作:

SELECT FirstName, LastName, PARSENAME(REPLACE('Long Live Pakistan', ' ', '.'), 2) AS Phrase
FROM EmployeeInfo einfo;

DECLARE @word varchar(20) = 'Live'

SELECT 
  FirstName, LastName, 
  CASE WHEN 'Long Live Pakistan' like '%'+@word+'%' THEN @word END AS Phrase
FROM EmployeeInfo