mssql 문자열 갯수 체크

CREATE FUNCTION dbo.fn_get_charcount(@src_str VARCHAR(8000), @find_str VARCHAR(4000))
RETURNS INT
AS
BEGIN

 DECLARE @char_count INT
 , @src_str_len INT
 , @find_str_len INT
 , @tmp_len INT

 SELECT @src_str_len = LEN(ISNULL(@src_str, '')), @find_str_len = LEN(ISNULL(@find_str, ''))

 IF @src_str_len < 1 OR @find_str_len < 1
 BEGIN
  RETURN 0
 END

 SELECT @tmp_len = LEN(REPLACE(@src_str, @find_str, ''))
 SELECT @char_count = (@src_str_len - @tmp_len) / @find_str_len

 RETURN @char_count
END