How to find the values have '%' in Sql-server

Question

delete member where accountid like '%%%'

https://stackoverflow.com/a/7191456/2864740 (specifically in the duplicate, as it contains a link to MSDN (which will also show the other common recommendation)) — user2864740, Jan 25 '22 at 09:58
can use xxx `like '%[%]%'` more info ref: https://stackoverflow.com/a/12897952/18026431 — s.w, Jan 25 '22 at 10:00
I've flagged this as a duplicate of the question everyone's linking - once the mods get to this particular question, this will likely be closed — Andrew Corrigan, Jan 25 '22 at 10:01

score 0 · Accepted Answer · answered Jan 25 '22 at 09:55

0

You can use this syntax:

delete member
where accountid like '%[%]%'

answered Jan 25 '22 at 09:55

Zakaria

1 Answers1