I'm trying to alter the query widget search expression to convert the input value to all upper case and the search input to all upper case. Even though there is a 'caseSensitive' parameter in the widget and it's set to false, my query will only work if using all caps.
For example, 935 2nd st sw will NOT work; while 935 2ND ST SW will work.
Below is a screenshot of the expression values I'm trying to get to work, but still don't.
Any input would be appreciated!