====== Microsoft - Microsoft SQL Server - SQL - Find - Find Data with Square Brackets ======

<code sql>
create View dbo.webMatDedup_TRI_LLO_PPP_Error_Report_O1
as
SELECT TOP (100) PERCENT zCheckwithingroup, zMatDedupID
from dbo.ztMatDedup
where zConfirmed = 1 and zActive = 1
and (description like '%[[]TRI]%'
or description like '%[[]LLO]%'
or description like '%[[]LLO%'
or LINK_CODE like '%PPP%')
and isnull(zMatDedupID,'')<>''
</code>