By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 1447721 fiddles created (18786 in the last week).
CREATE FUNCTION GetStringCount(@strValue VARCHAR(200), @charValue VARCHAR(200))
RETURNS VARCHAR(200)
AS
BEGIN
RETURN (DATALENGTH(@strValue) - DATALENGTH(REPLACE(@strValue, @charValue, ''))) / DATALENGTH(@charValue)
END