> ## Documentation Index
> Fetch the complete documentation index at: https://docs.sdf.com/llms.txt
> Use this file to discover all available pages before exploring further.

# String Functions

## `ascii`

*Supported Signatures*

```sql theme={null}
function ascii(string) returns int64
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#ascii)

## `byte_length`

*Supported Signatures*

```sql theme={null}
function byte_length $1($1) returns int64
	where $1 in (string, bytes)
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#byte_length)

## `char_length`

*Supported Signatures*

```sql theme={null}
function char_length(string) returns int64
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#char_length)

## `character_length`

*Supported Signatures*

```sql theme={null}
function character_length(string) returns int64
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#character_length)

## `chr`

*Supported Signatures*

```sql theme={null}
function chr(int64) returns string
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#chr)

## `code_points_to_bytes`

*Supported Signatures*

```sql theme={null}
function code_points_to_bytes(array<int64>) returns bytes
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#code_points_to_bytes)

## `code_points_to_string`

*Supported Signatures*

```sql theme={null}
function code_points_to_string(array<int64>) returns string
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#code_points_to_string)

## `collate`

*Supported Signatures*

```sql theme={null}
function collate(string, string) returns string
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#collate)

## `concat`

*Supported Signatures*

```sql theme={null}
function concat(bytes, ...) returns bytes
function concat(...) returns string
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#concat)

## `contains_substr`

*Supported Signatures*

```sql theme={null}
function contains_substr $1($1, string) returns bool
	where $1 in (string, bigint, bool, timestamp, time, date, datetime)
function contains_substr $1(array<$1>, string) returns bool
	where $1 in (string, bigint, bool, timestamp, time, date, datetime)
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#contains_substr)

## `ends_with`

*Supported Signatures*

```sql theme={null}
function ends_with $1($1, string) returns bool
	where $1 in (string, bytes)
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#ends_with)

## `format`

*Supported Signatures*

```sql theme={null}
function format(string) returns string
function format(string, $1) returns string
function format(string, $1, $2) returns string
function format(string, $1, $2, $3) returns string
function format(string, $1, $2, $3, $4) returns string
function format(string, $1, $2, $3, $4, $5) returns string
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#format)

## `from_base32`

*Supported Signatures*

```sql theme={null}
function from_base32(string) returns bytes
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#from_base32)

## `from_base64`

*Supported Signatures*

```sql theme={null}
function from_base64(string) returns bytes
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#from_base64)

## `from_hex`

*Supported Signatures*

```sql theme={null}
function from_hex(string) returns bytes
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#from_hex)

## `initcap`

*Supported Signatures*

```sql theme={null}
function initcap(string) returns string
function initcap(string, string) returns string
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#initcap)

## `instr`

*Supported Signatures*

```sql theme={null}
function instr(string, string) returns int64
function instr(string, string, int64) returns int64
function instr(string, string, int64, int64) returns int64
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#instr)

## `left`

*Supported Signatures*

```sql theme={null}
function left $1($1, int64) returns $1
	where $1 in (string, bytes)
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#left)

## `length`

*Supported Signatures*

```sql theme={null}
function length $1($1) returns int64
	where $1 in (string, bytes)
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#length)

## `lower`

*Supported Signatures*

```sql theme={null}
function lower(string) returns string
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#lower)

## `lpad`

*Supported Signatures*

```sql theme={null}
function lpad(string, int64, string) returns string
function lpad(string, int64) returns string
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#lpad)

## `ltrim`

*Supported Signatures*

```sql theme={null}
function ltrim(string) returns string
function ltrim(string, string) returns string
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#ltrim)

## `normalize_and_casefold`

*Supported Signatures*

```sql theme={null}
function normalize_and_casefold(string) returns string
function normalize_and_casefold(string, normalization_mode string) returns string
	where normalization_mode in (nfc, nfd, nfkc, nfkd)
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#normalize_and_casefold)

## `octet_length`

*Supported Signatures*

```sql theme={null}
function octet_length $1($1) returns int64
	where $1 in (string, bytes)
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#octet_length)

## `regexp_contains`

*Supported Signatures*

```sql theme={null}
function regexp_contains $1($1, string) returns bool
	where $1 in (string, bytes)
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#regexp_contains)

## `regexp_extract`

*Supported Signatures*

```sql theme={null}
function regexp_extract $1($1, string) returns $1
	where $1 in (string, bytes)
function regexp_extract $1($1, string, int64) returns $1
	where $1 in (string, bytes)
function regexp_extract $1($1, string, int64, int64) returns $1
	where $1 in (string, bytes)
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#regexp_extract)

## `regexp_extract_all`

*Supported Signatures*

```sql theme={null}
function regexp_extract_all $1($1, string) returns array<$1>
	where $1 in (string, bytes)
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#regexp_extract_all)

## `regexp_instr`

*Supported Signatures*

```sql theme={null}
function regexp_instr $1($1, $1) returns int64
	where $1 in (string, bytes)
function regexp_instr $1($1, $1, int64) returns int64
	where $1 in (string, bytes)
function regexp_instr $1($1, $1, int64, int64) returns int64
	where $1 in (string, bytes)
function regexp_instr $1($1, $1, int64, int64, int64) returns int64
	where $1 in (string, bytes)
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#regexp_instr)

## `regexp_replace`

*Supported Signatures*

```sql theme={null}
function regexp_replace $1($1, string, string) returns $1
	where $1 in (string, bytes)
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#regexp_replace)

## `regexp_substr`

*Supported Signatures*

```sql theme={null}
function regexp_substr $1($1, string) returns $1
	where $1 in (string, bytes)
function regexp_substr $1($1, string, int64) returns $1
	where $1 in (string, bytes)
function regexp_substr $1($1, string, int64, int64) returns $1
	where $1 in (string, bytes)
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#regexp_substr)

## `repeat`

*Supported Signatures*

```sql theme={null}
function repeat $1($1, int64) returns $1
	where $1 in (string, bytes)
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#repeat)

## `replace`

*Supported Signatures*

```sql theme={null}
function replace $1($1, string, string) returns $1
	where $1 in (string, bytes)
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#replace)

## `reverse`

*Supported Signatures*

```sql theme={null}
function reverse $1($1) returns $1
	where $1 in (string, bytes)
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#reverse)

## `right`

*Supported Signatures*

```sql theme={null}
function right $1($1, int64) returns $1
	where $1 in (string, bytes)
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#right)

## `rpad`

*Supported Signatures*

```sql theme={null}
function rpad(string, int64, string) returns string
function rpad(string, int64) returns string
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#rpad)

## `rtrim`

*Supported Signatures*

```sql theme={null}
function rtrim(string) returns string
function rtrim(string, string) returns string
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#rtrim)

## `safe_convert_bytes_to_string`

*Supported Signatures*

```sql theme={null}
function safe_convert_bytes_to_string(bytes) returns string
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#safe_convert_bytes_to_string)

## `soundex`

*Supported Signatures*

```sql theme={null}
function soundex(string) returns string
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#soundex)

## `split`

*Supported Signatures*

```sql theme={null}
function split $1($1) returns array<$1>
	where $1 in (string, bytes)
function split $1($1, $1) returns array<$1>
	where $1 in (string, bytes)
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#split)

## `starts_with`

*Supported Signatures*

```sql theme={null}
function starts_with(string, string) returns bool
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#starts_with)

## `substr`

*Supported Signatures*

```sql theme={null}
function substr(string, int64) returns string
function substr(string, int64, int64) returns string
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#substr)

## `substring`

*Supported Signatures*

```sql theme={null}
function substring $1($1, int64) returns $1
	where $1 in (string, bytes)
function substring $1($1, int64, int64) returns $1
	where $1 in (string, bytes)
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#substring)

## `to_base32`

*Supported Signatures*

```sql theme={null}
function to_base32(bytes) returns string
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#to_base32)

## `to_base64`

*Supported Signatures*

```sql theme={null}
function to_base64(bytes) returns string
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#to_base64)

## `to_code_points`

*Supported Signatures*

```sql theme={null}
function to_code_points $1($1) returns array<int64>
	where $1 in (string, bytes)
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#to_code_points)

## `to_hex`

*Supported Signatures*

```sql theme={null}
function to_hex(bytes) returns string
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#to_hex)

## `translate`

*Supported Signatures*

```sql theme={null}
function translate $1($1, $1, $1) returns $1
	where $1 in (string, bytes)
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#translate)

## `trim`

*Supported Signatures*

```sql theme={null}
function trim(string) returns string
function trim(string, string) returns string
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#trim)

## `unicode`

*Supported Signatures*

```sql theme={null}
function unicode(string) returns int64
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#unicode)

## `upper`

*Supported Signatures*

```sql theme={null}
function upper(string) returns string
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#upper)