https://www.omnidex.com/docs/v54/ 2026-05-01T11:07:32+0000 https://www.omnidex.com/docs/v54/ https://www.omnidex.com/docs/v54/lib/tpl/simple/images/favicon.ico text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=dev:sql:functions:contains:examples&rev=1467153531&do=diff Development: Omnidex SQL SQL Functions: $CONTAINS Overview | Syntax | Customization | Examples Examples Example 1: Column > select name, character_length(name) len from individuals; NAME LEN -------------------------------------------------- ----------- MS. MARY LEWIS 14 MRS. ALICE R TOLLIVER 21 MR. SIDNEY K TOLLIVER 2… text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=dev:sql:functions:contains:home&rev=1467153531&do=diff Development: Omnidex SQL SQL Functions: $CONTAINS Description | Syntax | Customization | Examples Description The $CONTAINS function expands the search capabilities of SQL to include more flexible textual searches. Most SQL statements are written with criteria in simple predicates, such as: FIRST_NAME = ‘William’. This predicate compares the entire contents of FIRST_NAME against the criteria ‘William’, providing no opportunities for more flexible searches. If the criterion does not mat… text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=dev:sql:functions:contains:syntax&rev=1467153531&do=diff Development: Omnidex SQL SQL Functions: $CONTAINS Description | Syntax | Customization | Examples Syntax $CONTAINS(column, 'criteria', [, options [,'label']]) column Required. The column against which the criteria should be applied. criteria Required. Criteria to be applied against the column, consisting of either simple keywords, or an expression. Expressions may contain nested parentheses, qualification functions, Boolean operators and other textual operators described in this docume…