strcontains performs a substring search, returning 1 or 0.
1 if found, 0 if not found.
SQL> select strcontains('AbracadabrA','abrA'); strcontains INTEGER _______________________________________________________________________________ 1 1 Rows. -- 0 msec. SQL> select strcontains('AbracadabrA','XZ'); strcontains INTEGER _______________________________________________________________________________ 0 1 Rows. -- 0 msec.