# ORD

## Syntax

```sql
ORD(str)
```

## Description

If the leftmost character of the string `str` is a multi-byte character, returns the code for that character, calculated from the numeric values of its constituent bytes using this formula:

```sql
(1st byte code)
+ (2nd byte code x 256)
+ (3rd byte code x 256 x 256) ...
```

If the leftmost character is not a multi-byte character, `ORD()` returns the same value as the [ASCII()](https://mariadb.com/docs/server/reference/sql-functions/string-functions/ascii) function.

## Examples

```sql
SELECT ORD('2');
+----------+
| ORD('2') |
+----------+
|       50 |
+----------+
```

## See Also

* [ASCII()](https://mariadb.com/docs/server/reference/sql-functions/string-functions/ascii) - Return ASCII value of first character
* [CHAR()](https://mariadb.com/docs/server/reference/sql-functions/string-functions/char-function) - Create a character from an integer value

<sub>*This page is licensed: GPLv2, originally from*</sub> [<sub>*fill\_help\_tables.sql*</sub>](https://github.com/MariaDB/server/blob/main/scripts/fill_help_tables.sql)

{% @marketo/form formId="4316" %}


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://mariadb.com/docs/server/reference/sql-functions/string-functions/ord.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.