Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Use of SQL COLLATE functionality in IS

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

Tags:
Former Member
Not what you were looking for? View more on this topic or Ask a question