'RIGHT' function not working as expected in MetaMatrix
Issue
-
When using the RIGHT function in a transformation, the resulting string value has one additional character than the specified parameter.
-
For example, RIGHT('HS1972',4) returns 'S1972' when '1972' is expected.
Environment
- MetaMatrix Enterprise Designer 5.5.4
- MetaMatrix Enterprise Server 5.5.4
- Oracle 10 Relational Database
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.