By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 756572 fiddles created (13533 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
