適用于字符更多的字符串。

CREATE FUNCTION dbo.CountOccurrencesOfString

(

? ? @searchString nvarchar(max),

? ? @searchTerm nvarchar(max)

)

RETURNS INT

AS

BEGIN

? ? return (LEN(@searchString)-LEN(REPLACE(@searchString,@searchTerm,'')))/LEN(@searchTerm)

END

用法：

SELECT * FROM MyTable

where dbo.CountOccurrencesOfString(MyColumn, 'MyString') = 1