---
title: ES|QL RIGHT function
description: 
url: https://www.elastic.co/docs/reference/query-languages/esql/functions-operators/string-functions/right
products:
  - Elasticsearch
---

# ES|QL RIGHT function
## Syntax

![Embedded](https://www.elastic.co/docs/reference/query-languages/esql/images/generated/x-pack-esql/functions/right.svg)


## Parameters

<definitions>
  <definition term="string">
    The string from which to returns a substring.
  </definition>
  <definition term="length">
    The number of characters to return.
  </definition>
</definitions>


## Description

Return the substring that extracts *length* chars from *str* starting from the right.

## Supported types


| string  | length  | result  |
|---------|---------|---------|
| keyword | integer | keyword |
| text    | integer | keyword |


## Example

```esql
FROM employees
| KEEP last_name
| EVAL right = RIGHT(last_name, 3)
```


| last_name:keyword | right:keyword |
|-------------------|---------------|
| Awdeh             | deh           |
| Azuma             | uma           |
| Baek              | aek           |
| Bamford           | ord           |
| Bernatsky         | sky           |