Use of SQL COLLATE functionality in IS

[Former Member]

Hi!

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.

Thanks!!

Alberto Páez

[Binoy]

Hello Alberto ,

Did you manage to find solution to the above issue ? I do have a similar scenario with vendor master where I am trying to fail all vendors which do not have all letters in upper cases .

Please advise .