score:3

Accepted answer

The 'value' field is obviously a string since it's retained the leading zeroes. I've not tried but can you not cast the value as an integer before doing the comparison? Something like:

from t in table
where (t => Convert.ToInt32(t) == 33)
select t

If you need to keep the value as a string, you could use string.EndsWith() but you might have problems with matching the correct 'value'.


Related Articles