Dataview filter all columns

[rwildcard]

Hi,
I would like to add a rowfilter that will get all rows that have a keyword in them, I was wondering if that is possible or do I have to write a crazy [col-name] = value OR [col-name]= value OR...etc for like 12 columns. I know I am lazy, but I have searched the web and I cant find an article on it. Please let me know what I can do. Thanks a bunch.
Ry

[miranda]

other than write the query out by hand the only thing close I have found is this article (http://vyaskn.tripod.com/search_all_columns_in_all_tables.htm) for sql server which searches all tables. if you use sql server you could adapt it to just search the individual table.