I have a grid bound to a DataView. The underlying DataTable has case sensitivity turned on because the SQL 2005 database uses the Latin1_General_BIN (case sensitive) collation.

When I build a RowFilter expression using LIKE, it is treated as case sensitive, but I want to be able to do case insensitive filtering. I experimented using a ">=" AND "<" expression, but then I lose wild card capability and I can't use that approach if I want to find all rows with data greater than (or less than, etc) a specified string.

Any suggestions will be appreciated. Thanks in advance.

Odd, the docs for the DataColumn.Expression property state....

To concatenate a string, use the + character. The value of the CaseSensitive property of the DataSet class determines whether string comparisons are case-sensitive. However, you can override that value with the CaseSensitive property of the DataTable class.

This is our code:

' Temporarily suspend adding new rows. Re-allow it when they're not filtering.

Grid.AllowAddNew = False

Grid.AllowDelete = False

Grid.AllowUpdate = False

Try

CType(BindingSource.DataSource, DataView).Table.CaseSensitive = False

Catch EX As Exception

Debug.WriteLine("Constraint exception setting CaseSensitivity to False: " & EX.Message)

End Try

If all else fails...you can do something like...

use "Select t.*, Upper(coalesce(t.[Description],'')) as UpperDescription from table1

for selection then filter on the pseudo-field.