SQL Server 2014

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
--CREATE TWO IDENTICAL TABLES AND INSERT SOME DATA
CREATE TABLE t1 ( biosname VARCHAR(100));
CREATE TABLE t2 ( biosname VARCHAR(100));
INSERT INTO t1 VALUES ('-[VVE172BUS-3.30]-');
INSERT INTO t2 VALUES ('-[VVE172BUS-3.30]-');
2 rows affected

--WITH THE OPERATEUR = ALL IS WELL
SELECT * FROM  t1 WHERE biosname = '-[VVE172BUS-3.30]-';

biosname

-[VVE172BUS-3.30]-

--BUT WITH LIKE WE GET NO RESULT
SELECT * FROM  t1 WHERE biosname LIKE '-[VVE172BUS-3.30]-';

biosname

--WE CAN USE AN ESCAPE CHARACTER IF WE DECLARE IT
SELECT * FROM  t1 WHERE biosname LIKE '-\[VVE172BUS-3.30]-' ESCAPE '\';

biosname

-[VVE172BUS-3.30]-

--THE SAME RULES APPLY FOR COMPARING 2 FIELDS
--ALL IS WELL IF WE USE +
Select * from t1, t2
where t1.biosname = T2.biosname;

biosname
biosname

-[VVE172BUS-3.30]-
-[VVE172BUS-3.30]-

--TO USE ESCAPE LIKE WE HAVE THE REPLACE '[' WITH '\[' 
Select * from t1, t2
where t1.biosname like REPLACE(t2.biosname, '[', '\[') escape '\'

biosname
biosname

-[VVE172BUS-3.30]-
-[VVE172BUS-3.30]-