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?
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?