I have a grid with two columns that are nullable in the database. They are returning empty strings when bound to the grid. I've found some interesting behavior when I play with the filters. If I use the "Starts with" filter, I get the expect number of rows back. However, if I use the "Ends with" filter, I get the expected number of rows plus all of the rows that have no value for that field. Is this expected behavior? If so, it is extremely inconsistent and not really in line with user expectations. Is there a way to get only the rows that actually end with the expected value back?
Thanks,
Jodi
Thanks,
Jodi