>If am trying to Set Filter to last_name = "smith".
>In the table the last_name = "SMITH".
>I do not want to convert lowercase to uppercase,
>I want to filter to find "SMITH" from "smith"?
>Set Exact Off does not seem to work.

SET FILTER to UPPER(last_name)="SMITH"