While comparing the data which has square brackets Ex: '-[VVE172BUS-3.30]-' I am using below
Select * from ServerOps.dbo.tbl_VmHealth_Firmware where biosname like '-[[]VVE172BUS-3.30]-'
AND i am getting the right outout however I need to compare biosname '-[VVE172BUS-3.30]-' with another column from different table. Could you pls help me how to escape the [] while joining two columns
SELECT VmhostName, ParentName, DataCenterName,VcenterName,
VF.Manufacturer, VF.Model, VF.BiosVersion, MAX(VF.ReleaseId) AS ReleaseId
FROM ServerOps.dbo.tbl_VmHealth_Vmhost VH WITH (NOLOCK)
LEFT JOIN ServerOps.dbo.tbl_VmHealth_Firmware VF WITH (NOLOCK)
ON VH.Manufacturer LIKE '%' VF.Manufacturer '%' AND VH.Model = VF.Model
AND VH.BiosVersion LIKE '%' VF.BiosVersion '%'
AND ((VH.ReleaseDate >= VF.ReleaseDate AND VH.Manufacturer not like '