You’re going to want to kill me but:
I misapplied your suggestion and instead of doing ‘%[*]%’ I typed [%*%]
Your suggestion did work. I typed it wrong.
Sorry to put you through the test scenario over my mistake.

What is the significance of the [] brackets? I tried to search help but help doesn’t accept [ as a search.

Thanks,

Chris

>I do not know what is the problem, but I test this on VB. NET and C# with Northwind database. I just drag Categories table on the form, generate DataSet on the SqlDataAdapter and place DataView on the form, which I bind to the Categories table into DataSet. After that I put DataGrid and bind it to the DataView. In form load I put:
>

>private void Form1_Load(object sender, System.EventArgs e)
>{
>	sqlDataAdapter1.Fill(dataSet11.Categories);
>	dataView1.RowFilter="CategoryName LIKE '%[*]%'";
>}
>

>
>In Categories table there are no category names, which includes '*', so I change one name to contain '*'. Everything works well: no errors at compile or run-time and only this category is shown in the DataGrid...
>
>So, I suppose that the problem is not with LIKE filter, but with your SELECT query to the database...