SQL Occurrence of character in a string ? DECLARE @Temp nvarchar(MAX)='1234ABCDEFGHIJThis IsA,Test' DECLARE @SearchChar nvarchar(MAX)=',' SELECT (LEN(@Temp) - LEN(REPLACE(@Temp, @SearchChar, '')))