Luis Cazares solution works for me. Thanks!
Luis Cazares (12/2/2013)
You could use an ESCAPE character.
End SQL:
DECLARE @Table1 TABLE
(
Column1 VARCHAR(32) NOT NULL PRIMARY KEY
);
INSERT @Table1(Column1)
VALUES
('abcdef123'),
('abcdef]123'),
('abcdef[123'),
('abcdef].123'),
('abcdef)123'),
('abcdef.123');
SELECT T.Column1
FROM @Table1 T
WHERE T.Column1 LIKE '%[.\]]123%' ESCAPE '\';