Hello,

I need to do a customer search using the Sage 300 Web API, but it needs to be case insensitive as some customer names are proper and some are in all caps.  According to the OData documentation I should be able to use the tolower function, but I get an internal server error if I try this.  Here is what my call looks like...

http://localhost/Sage300WebApi/v1.0/-/SAMLTD/AR/ARCustomers?$filter=startswith(tolower(CustomerName),'david')

This should return customers with the CustomerName 'david', 'David', 'DAVID' or even 'dAvid' (if it existed).

The startswith works fine, and I tried using the tolower by itself and I get the Internal Server Error 500 so I know it must be this particular function that it doesn't like.  So how can I do this kind of search?

Any help is much appreciated.

Thanks,

Ryan