另一种方法是：

DECLARE @word varchar(max) = '#COIN-XXXX This is and example data only'
DECLARE @c varchar(100) = '#COIN1-'
DECLARE @CharIndex int = (select CHARINDEX(@c, @word))
if @CharIndex = 0
    select 'No matching word'
DECLARE @firstSpaceAfter_index int = (select CHARINDEX(' ', @word, @CharIndex))
if @firstSpaceAfter_index = 0
    set @firstSpaceAfter_index = len(@word) + 1

SELECT REPLACE(SUBSTRING(@WORD, @CharIndex, @firstSpaceAfter_index - @CharIndex),@c, '')

一种方法是：

select left(v.str, charindex(' ', v.str) - 1)
from (select @c as str) x cross apply
     (values (stuff(x.str, 1, charindex('#COIN', x.str) + 5, ''))) v(str);

这是一把小提琴。