Contains Operator


<string expression> contains
<sub-string expression>


The contains operator determines whether a specified string includes a specified substring. The contains operator is case-insensitive, that is, it compares the string regardless of case.


Type the following lines in the Message Box and press Enter after each: put "Happy Birthday!" into A put "birthday" into B A contains B Oracle Media Objects returns true in the Message Box because "birthday" is a substring of "Happy Birthday!" Create a field and name it "MyBirthday". Type "Happy Birthday" in field "MyBirthday". Then type the following line in the Message Box and press Enter:
This text has been mechanically extracted from the Oracle Media Objects MediaTalk Reference, © 1995 Oracle Corporation, and is provided here solely for educational/historical purposes.