The following are the string operators in ElevateDB, ordered by their operator precedence:


Examples

---

-- The following uses the text index
-- on the Notes column to find any rows
-- where the word 'angry', 'anger', or 'angered'
-- appears.

SELECT *
FROM customers
WHERE Notes CONTAINS ANY 'angry anger angered'

-- The following uses the text index
-- on the Text column to find any rows
-- where the words 'little', 'red',
-- 'riding', and 'hood' appear

SELECT *
FROM Documents
WHERE Text CONTAINS 'little red riding hood'

SQL 2003 Standard Deviations

---

The following areas are where ElevateDB deviates from the SQL 2003 standard: