The UPPER() function is very useful for doing partial-match searches, but is not supported in SWQL API.
When a user enters a partial-match search term, they may not know the correct upper/lower case for the term, but they expect the search results to return any upper/lowercase match.
The easiest way to accomplish this is to upper-case the user input and use UPPER() when comparing records. For example:
User-requested search term: core
Query:
SELECT SysName FROM Orion.Nodes WHERE UPPER(SysName) LIKE '%CORE%'
Results:
Central.Core
backbone-core
CORE1_router
