SQL escape special characters - need help

Nine Stars

SQL escape special characters - need help

I have a tTeradataInput component which I am trying to run more complex SQL.
Usually it runs fine but this time my SQL has single quotes, vertical pipes, plus signs, exclamations marks, equal signs
I am pretty sure the problem is the exclamations marks, how do I get Talend to ignore it and pass it to the database?
example:
AND t1.col1         != t2.col2
AND t2.col1         != t1.col1
Nine Stars

Re: SQL escape special characters - need help

This works:
AND t1.col1 <> t2.col2
AND t2.col1 <> t1.col1
Any ideas how to make != work?