The Developer Zone

			
                            CREATE FUNCTION CountChar(@strInput VARCHAR(1000), @strChar CHAR(1)) RETURNS INT
                            BEGIN
                                RETURN (LEN(@strInput) - LEN(REPLACE(@strInput, @strChar, '')))
                            END
                            GO