Question: I want to delete a record which contains `%` sign, for example:

> 
> white%House, Den%mark, bengali%20Tiger, White%202. 
> 
> 
> 

I have this query but it doesn't work for me.

```
delete from nail where name like '%[%]%'

```

I am using C# and Access.

Answer: 
The following worked for me native in MS Access

```
DELETE foo.foo1
FROM foo
WHERE (((foo.foo1) ALike "%[%]%"));

```

Maybe it's the double quotes instead of the apostrophes.

Perhaps in C# you need to do something like

```
bar = "DELETE foo.foo1 FROM foo WHERE (((foo.foo1) ALike \"%[%]%\"));";

```
try:

```
delete from nail where name like '%[[%]%'

```