OData substringof or thw 'Like' in sql


was trying to do a OData filter, using substringof, to replicate a Like '1,% 4,%' of SQL, but itt says "An unknown function with name 'substringof' was found." . Is there any way to do this filter without using a ServerMethod.


You can use contains:

substringof was part of OData v3 and no longer available in OData v4