API OData filtering (startswith and substringof)

I was just trying $filter=

• contains (not supported)
• substringof and startswith (appears to be ignored, returns all results)

eg.

I've tried multiple variations of the filters.

For clarification, the proper way to apply the filters should be:

- For startswith and endswith, it should be (Project,'ABC') - this was used the other way around from the screenshots

- For substringof, it should be ('ABC', Project) being 'ABC' the string you want to filter by. It is different to the endswith and startswith commands which have 'project' first.