All Forums Database
david powell 1 post Joined 05/13
09 Dec 2013
"CONTAINS" opertator

New to Teradata.  Does teradata use the "CONTAINS" operator?
If so are there additional information concerning this operator in relation to properly setting up indexs?
david powell

tomnolan 594 posts Joined 01/08
09 Dec 2013

For questions about functions and operators, you should refer to the Teradata Database SQL Reference volume "SQL Functions, Operators, Expressions, and Predicates". All Teradata documentation is available from
Teradata has a CONTAINS operator which evaluates whether one temporal or period expression contains another temporal or period expression.
You may be referring to a different kind of CONTAINS operator, such as Oracle Text's CONTAINS function, which is somewhat comparable to a LIKE predicate.

You must sign in to leave a comment.