RE: Accent insensitive dataview.rowfilter

Hi,

First of all, I would like to confirm my understanding of your issue. From
your description, I understand that you need to filter out the rows that
contains accented characters. If there is any misunderstanding, please feel
free to let me know.

In this case, I think LIKE operater with wildcard character can do it for
you. In the DataView.RowFilter property, we can do like the following

dv.RowFilter = "LastName LIKE '%u%' OR LastName LIKE '%a%'";
(Sorry, I can't input accented characters on my machine. So I used a and u
instead.)

This will filter out all the rows containing these characters in the table.

HTH.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."

.

Relevant Pages

  • Re: Like operator with accented character
    ... The accented characters are being included in this filter without being ... >>characters listed but the query also excludes accented characters? ... The ASCII value for accented characters is is different than the ...
    (microsoft.public.access.queries)
  • Re: Like operator with accented character
    ... >characters listed but the query also excludes accented characters? ... >a way that accented characters are not included in this filter? ... The ASCII value for accented characters is is different than the ...
    (microsoft.public.access.queries)
  • Like operator with accented character
    ... characters listed but the query also excludes accented characters? ... a way that accented characters are not included in this filter? ... Regards ... Prev by Date: ...
    (microsoft.public.access.queries)
  • Re: List the products whos unit sales increasing for the last 4 months
    ... I couldn't get the hang of ... and what is that the filter is working on ... Please explain for understanding it better ... Prev by Date: ...
    (microsoft.public.sqlserver.olap)
  • Re: List the products whos unit sales increasing for the last 4 months
    ... I couldn't get the hang of ... and what is that the filter is working on ... Please explain for understanding it better ... Prev by Date: ...
    (microsoft.public.sqlserver.olap)