SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

SQL/MX Functions and Expressions
HP NonStop SQL/MX Reference Manual—523725-004
9-171
Examples of UPSHIFT
•
Suppose that your database includes two department tables: DEPT1 and DEPT2.
Return all rows from the two tables in which the department names have the same
value regardless of case:
SELECT * FROM persnl.dept1 D1, persnl.dept2 D2
WHERE UPSHIFT(D1.deptname) = UPSHIFT(D2.deptname);