Phani1
Databricks MVP

Thanks for your quick response and for providing the solution. However, the view-based approach is causing the same issue—since it still involves converting the UNICODE_CI column to a regular string, we may lose case-insensitive behavior and not get the expected results.