Use of SQL COLLATE functionality in IS
In the developing of our Business Rules we have a validation that checks that the NAME1 for Customers is always entered in Upper Case letters.
The issue is that not all our customers are entered in Latin Characters, so we use to have a function in our WHERE condition in SQL to handle this
NAME1 COLLATE Latin1_General_CS_AS <> UPPER(NAME1)
Is there any way to do this or something similar to this inside Information Steward? We would love to be able to handle this inside the Rule development in IS and don't have to handle it by Data Base view or something similar.