SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE FUNCTION [General].[ContarCaracter]
(
@StringCaracter varchar(max),
@Caracter varchar(max)
)
RETURNS int
AS
BEGIN
DECLARE @Cuenta int
set @Cuenta = (len(REPLACE(@StringCaracter,' ','')) - len(replace(replace(@StringCaracter,' ',''), @Caracter, '')))/LEN(@Caracter)
RETURN @Cuenta
END
Comentarios sobre la versión: 1.0 (0)
No hay comentarios