带有like和not like运算符的Where子句不起作用

Question

我有这个查询：

SELECT 
DISTINCT 
REPLACE(REPLACE(A.[NOME COMERCIAL],'.',''),'&','') AS [NOME COMERCIAL]        ,
ISNULL(A.[PLANO], '') AS PLANO       ,
A.[Plano Foco]        ,
CONVERT(DECIMAL(18,2),A.[PRECO]) AS PRECO        ,
B.[FEAT_CAMERA]        ,
B.[FEAT_TELA]        ,
B.[FEAT_CAP_ARMAZENAMENTO]        ,
B.[FEAT_PROCESSADOR]        ,
B.[FEAT_MEMORIA_RAM]        ,
B.[FEAT_BATERIA]        ,
B.[EXTRA_INFO_1]        ,
B.[EXTRA_INFO_2]        ,
B.[EXTRA_INFO_3]  
FROM [TABELA DE PRECOS] AS A
LEFT JOIN DE_PARA_SAP_APARELHOS AS B
ON (A.[NOME DPGC] = B.APARELHODPAV)
WHERE PLANO LIKE '%CONTROLE%'
AND PLANO NOT LIKE '%Renova%'
AND A.[PRODUTO] IN ('Smartphone', 'Blackbox 3G', 'Blackbox 4G', 'Fixo', 'Modem 3G', 'Modem 4G', 'Tablet')
AND REPLACE(REPLACE(REPLACE(A.[NOME DPGC],'&',''),'''',''),'.','') = 'Iphone XR 64GB' 
OR REPLACE(REPLACE(REPLACE(B.[APARELHODPAV],'&',''),'''',''),'.','') = 'Iphone XR 64GB'
AND A.[REGIAO] = '7x'
ORDER BY PRECO,[PLANO]  

我搜索了一下，发现如果你有空值，LIKE和NOT LIKE就不能正常工作，所以我使用ISNULL。但我仍然得到包含"Renova"的值：

Novo Vivo V (Renova)
Novo Vivo V
Vivo Família 70GB (Renova)
Vivo Família 50GB (Renova)
Vivo Família 70GB
Vivo Controle....

我没有收到任何错误消息。查询运行得很好，但就像我的类运算符和非类运算符被忽略一样。我在这里错过了什么？

Answer 1

括号：

SELECT DISTINCT REPLACE(REPLACE(A.[NOME COMERCIAL],'.',''),'&','') AS [NOME COMERCIAL]        ,
ISNULL(A.[PLANO], '') AS PLANO       ,
A.[Plano Foco]        ,
CONVERT(DECIMAL(18,2),A.[PRECO]) AS PRECO        ,
B.[FEAT_CAMERA]        ,
B.[FEAT_TELA]        ,
B.[FEAT_CAP_ARMAZENAMENTO]        ,
B.[FEAT_PROCESSADOR]        ,
B.[FEAT_MEMORIA_RAM]        ,
B.[FEAT_BATERIA]        ,
B.[EXTRA_INFO_1]        ,
B.[EXTRA_INFO_2]        ,
B.[EXTRA_INFO_3]  
FROM @A AS A 
LEFT JOIN @B AS B  ON 
A.[NOME DPGC] = B.APARELHODPAV
WHERE   PLANO LIKE '%CONTROLE%'  AND 
PLANO NOT LIKE '%Renova%'  AND 
A.[PRODUTO] IN ('Smartphone', 'Blackbox 3G', 'Blackbox 4G', 'Fixo', 'Modem 3G', 'Modem 4G', 'Tablet')  AND 
(REPLACE(REPLACE(REPLACE(A.[NOME DPGC],'&',''),'''',''),'.','') = 'Iphone XR 64GB' OR REPLACE(REPLACE(REPLACE(B.[APARELHODPAV],'&',''),'''',''),'.','') = 'Iphone XR 64GB') AND 
A.[REGIAO] = '7x' 
ORDER BY PRECO,[PLANO]  

Answer 2

如果您不想包含Renova，请不要将其包含在where子句中，它将被排除在选择之外。这将解决你的问题。