I am using sap url to fetch data, I have to perform case insensitive search

[former_member1311934]

$filter=(OrdNo eq '2012') and (substringof('00', CandNo)) and ((substringof('Test', FirstName)))

I have to perfrom case insensitive search on this url, So how to use tolower or toupper on this

substringof('Test',tolower(FirstName) like '%25ca%25') I tried this but getting

error: message":{"lang":"en","value":"Invalid parameter for function 'substringof'"

I also tried using %25ca, ca%25 but getting same error

[Former Member]

Thank you for visiting SAP Community to get answers to your questions. Since you're asking a question here for the first time, I recommend that you familiarize yourself with: https://community.sap.com/resources/questions-and-answers, as it provides tips for preparing questions that draw responses from our members.

For example, you can:

- outline what steps you took to find answers (and why they weren't helpful)

- share screenshots of what you've seen/done

- make sure you've applied the appropriate tags

- use a more descriptive subject line

The more details you provide, the more likely it is that members will be able to respond. Feel free to also take our Q&A tutorial at: https://developers.sap.com/tutorials/community-qa.html

Should you wish, you can revise your question by selecting Actions, then Edit.

By adding a picture to your profile you encourage readers to respond: https://developers.sap.com/tutorials/community-profile.html
Questions on how to draw responses from members? Check out this discussion on how to improve questions. https://groups.community.sap.com/t5/welcome-corner-discussions/advice-from-sap-champions-questions-a...