Using View Criteria to Query Case-Insensitively
If you want to filter in a case-insensitive way, you can use the upper() function around the field name in the filter.
If you're not sure whether the operand value is uppercase, you can also use the
upper()
function around the operand like this:
-
upper(JustificationCode) = 'BRK'
-
upper(JustificationCode) = upper(:codeVar)
-
upper(JustificationCode) like upper(:codeVar)||'%'