In MSSQL database environments, you must create a function that removes non-alphanumeric characters by creating the following function. When installing, CIM will create all of the necessary tables, objects, and indexes. By default, these are configured to update in real-time. Refer to your MSSQL documentation for additional information.

CREATE FUNCTION dbo.fnRemovePatternFromString(@BUFFER VARCHAR(MAX), @PATTERN
VARCHAR(128)) RETURNS VARCHAR(MAX) AS
BEGIN
    DECLARE @POS INT = PATINDEX(@PATTERN, @BUFFER)
    WHILE @POS > 0 BEGIN
        SET @BUFFER = STUFF(@BUFFER, @POS, 1, '')
        SET @POS = PATINDEX(@PATTERN, @BUFFER)
    END
    RETURN @BUFFER
END