Home > Blockchain >  Escape square brackets from Like statement in two table joining
Escape square brackets from Like statement in two table joining

Time:03-17

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 '           
  • Related