InterSystems IRIS TSQL Code 445 COLLATE clause cannot be used on express

In this post, you’ll learn about the SQL error code 445 in InterSystems IRIS database the reason why you are receiving the TSQL message when using the InterSystems IRIS data platform

Error Code :

445

Reason for the Error code 445 in InterSystems IRIS DBMS

COLLATE clause cannot be used on expressions containing a COLLATE clause.