microsoft:microsoft_sql_server:sql:find:find_data_with_square_brackets
Microsoft - Microsoft SQL Server - SQL - Find - Find Data with Square Brackets
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,'')<>''
microsoft/microsoft_sql_server/sql/find/find_data_with_square_brackets.txt · Last modified: 2021/08/05 13:36 by peter