Hi,
From Denodo Platform 8.0, the [contains](https://community.denodo.com/docs/html/browse/8.0/en/platform/upgrade/backward_compatibility/changes_in_the_denodo_platform_8.0/features_removed_from_virtual_dataport#contains-containsand-containsor-and-iscontained-operators) operator is replaced with **POSITION** function. Hence, in order to filter the data that contains certain values from a specified column, I would follow the below suggestions,
* To filter the data by querying the view from Virtual DataPort, for example,
* If the query has "field1 containsand ('arg0', 'arg1')"
use,
***POSITION(UPPER('arg0') IN UPPER(field1)) > 0 AND POSITION(UPPER('arg1') IN UPPER(field1)) > 0***
* When I use OData interface to query the views from Denodo Platform, I would use the [Advanced Querying](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/restful_architecture/odata4_service/odata4_service_querying_data_advanced#selection-filter) option to filter the data based on a value contained in a column. For example,
***/denodo-odata.svc/<viewname>?$filter=contains(fieldname,'value')***
Hope this helps!
