Simple RowFilter Question

J

James

Have a DataView that I need to filter by the first letter of a field. I
want to be able to filter by "NonAlpha" (i.e. it begins with a number or
something else).

I tried:

dv.RowFilter = "(ASCII(SUBSTRING(List_Name, 1, 1)) BETWEEN 32 AND 64) OR
(ASCII(SUBSTRING(List_Name, 1, 1)) BETWEEN 91 AND 96) OR
(ASCII(SUBSTRING(List_Name, 1, 1)) BETWEEN 123 AND 255)"

....but this fails. Thoughts?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
474,431
Messages
2,571,679
Members
48,796
Latest member
Greg L.

Latest Threads

Top