Selecting specific Columns from a Dataset?

[Tmuldoon]

Hello,
I have a complete table within a dataset.


I want a dataview to show particular filtered data - works great with
the dv.rowfilter.


But can I display only certain columns that are filtered?


Right now in my rowfilter I have something like this:


dv.RowFilter = "Title like '%Whales%' OR Genus like 'Megaptera'"


This prints all of the fields in the table (30). I want to show only 4
fields


I cannot get a away with:


dv.rowfilter = "select Title, Genus, [Climate ID], Endangered from
Animals where Title like '%Whales%' OR Genus like 'Megaptera'"


I get this error: Missing operand after 'Title' operator


*Note "Climate ID" is the name of a column (yes it has a space in it so
I bracketed it).


So in row filter you cannot put in a full sql statement....


The dataset cannot be changed.


Anyway to pull specific columns from this table?


Thanks,


Tmuld.