使用SQL搜索字符串中的单词数

declare @search varchar(10) = 'I'select len(replace(PageText, @search, @search + '#')) - len(PageText) as Count from YourTable