# STRPOS

Returns the starting position of the first instance of a given substring within a string.

## Syntax

```
STRPOS(STRING, SUBSTRING)
```

## Arguments

#### STRING

Type: `string`

A sequence of characters to search.

#### SUBSTRING

Type: `string`

The substring to search for.

## Returns

Type: `bigint`

Returns the starting position of the first instance of `SUBSTRING` in `STRING`.

Positions start from `1`. If no instance is found, `0` is returned.

***

## Examples

| STRING | SUBSTRING | Output |
| --- | --- | --- |
| All happy families are alike | all | 0 |
| All happy families are alike | All | 1 |
| All happy families are alike | are | 20 |
| All happy families are alike | `''` | 1 |
| `''` | `''` | 1 |
| `''` | word | 0 |
| `null` | word | `null` |