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