oData V4 case sensitive and incase sensitive is not working

[jmfarook]

`http://services.odata.org/V4/Northwind/Northwind.svc/Employees/?$filter=contains(toupper(FirstName),%27C%27)

http://services.odata.org/V4/Northwind/Northwind.svc/Employees/?$filter=contains(tolower(FirstName),%27C%27)`

this is query string but it always return both lower and uppercase

[mtroth-microsoft]

Hi. not sure I am following the question. this query: http://services.odata.org/V4/Northwind/Northwind.svc/Employees/?$count=true&$select=FirstName shows a count of 9. this query: http://services.odata.org/V4/Northwind/Northwind.svc/Employees/?$filter=contains(tolower(FirstName),'C')&$count=true&$select=FirstName shows a count of 2.

This is expected behavior if the service in question is has configured case insensitivity to be on, which the V4 service has done.