I have a numeric SQL column that I’m wanting to search on but I’m not able to find an oData equivalent.
For example, in SQL I would use:
SELECT * FROM MyTable WHERE Id LIKE '%123%'
I’ve tried the following for oData but no luck:
contains(Id,123)
contains(Id,'123')
The error I get is:
The query specified in the URI is not valid. No function signature for the function with name 'contains' matches the specified arguments.
Any ideas?