Searching for a number with a wildcard using oData

Question

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?

Answer 1

Use function substringof:

substringof('123',Id)