0
select * from Answers where AnswerName like '%No [DETAILS REQUIRED]%'

The above-given query does not return any results while there is an entry in the column "AnswerName " with the exact text as "No [DETAILS REQUIRED]"

Siddharth Bharadwaj
  • 81
  • 6

2 Answers2

2

you can use an escape character:

select * from Answers where AnswerName like '%No \[DETAILS REQUIRED\]%' escape '\'
SqlZim
  • 37,248
  • 6
  • 41
  • 59
0

use escape character

match_expression [ NOT ] LIKE pattern [ ESCAPE escape_character ]  

select * 
from Answers 
where AnswerName like '%No @[DETAILS REQUIRED@]%' ESCAPE '@'
MtwStark
  • 3,866
  • 1
  • 18
  • 32