DataView / RowFilter problems

[Robert Doyle]

Hi
I have a Table of 14067 rows in a DataSet all fine.

If I create a RowFilter based on a column called County which is a varchar(40)
i.e.
string strRowFilter = "County = 'Meath'";
DataView dv = new DataView(mds.Tables[mstrTableName],
strFilter,
mstrKey,
DataViewRowState.CurrentRows);

Works fine, responds with a DataView of 447 rows, great!

But if I try a RowFilter based on a Integer column Price.
i.e.
string strRowFilter = "Price > 300000";
DataView dv = new DataView(mds.Tables[mstrTableName],
strFilter,
mstrKey,
DataViewRowState.CurrentRows);

I get a DataView with 8 rows but there are 9068 rows which match.
The 8 rows I get are all in the first 10 rows of the table.
I've tried about 100 combinations but I always seem to get a small subset of the view I'm looking for also a RowFilter of "County IN ('Meath')" returns a DataView with 0 rows also...

Any ideas.
Thanks in advance.

Thanks
Rob