STARTING WITH

Data Types and SubtypesData Definition (DDL) Statements

`STARTING WITH`

Syntax

<value> [NOT] STARTING WITH <value>

The STARTING WITH predicate searches for a string or a string-like type that starts with the characters in its value argument.The case- and accent-sensitivity of STARTING WITH depends on the collation of the first value.

When STARTING WITH is used in the search conditions of DML queries, the Firebird optimizer can use an index on the searched column, if it exists.

Example

Search for employees whose last names start with “Jo”:

SELECT LAST_NAME, FIRST_NAME
FROM EMPLOYEE
WHERE LAST_NAME STARTING WITH 'Jo'

`CONTAINING`

Syntax

<value> [NOT] CONTAINING <value>

The CONTAINING predicate searches for a string or a string-like type looking for the sequence of characters that matches its argument.It can be used for an alphanumeric (string-like) search on numbers and dates.A CONTAINING search is not case-sensitive.However, if an accent-sensitive collation is in use then the search will be accent-sensitive.

Examples

Search for projects whose names contain the substring “Map”:
```
SELECT *
FROM PROJECT
WHERE PROJ_NAME CONTAINING 'Map';
```
Two rows with the names “AutoMap” and “MapBrowser port” are returned.
Search for changes in salaries with the date containing number 84 (in this case, it means changes that took place in 1984):
```
SELECT *
FROM SALARY_HISTORY
WHERE CHANGE_DATE CONTAINING 84;
```