You could use an ESCAPE character.

DECLARE @Table1 TABLE

(

Column1 VARCHAR(32) NOT NULL PRIMARY KEY

);

INSERT @Table1(Column1)

VALUES

('abcdef123'),

('abcdef]123'),

('abcdef].123'),

('abcdef)123'),

('abcdef.123');

SELECT T.Column1

FROM @Table1 T

WHERE T.Column1 LIKE '%\]123%' ESCAPE '\'

OR T.Column1 LIKE '%.123%';