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: 
I think there is some confusion going on, so here is a complete code example that works for me:

```
using ( var conn = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\users\john\desktop\Database11.accdb;Persist Security Info=False;"))
{
     conn.Open();
     OleDbCommand cmd = 
         new OleDbCommand("DELETE FROM TABLE1 where [name] like '%[%]%'", conn);
     cmd.ExecuteNonQuery();

     cmd.Dispose();
     conn.Close();
}

```

Note that you are using "name" as one of your fields, which is a reserved word, so you need to escape it inside of brackets. The same goes for the %, since it is the wildcard character that is used by OLEDb.
try:

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

```