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: 
You can use `InStr()` to find if the name contains %

```
where InStr(name, '%') > 0

```
try:

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

```