# SUBSTR

```
SUBSTR(expr, startIndexExpr)
```

Returns a new string that is a substring of this string.

Available in:

| Processors | SQL Studio |
| ---------- | ---------- |
| ✓          | ✓          |

*Sample code:*

```sql
USE `kafka`;
SELECT 
    SUBSTR(email, 10 , 20),
    email 
FROM users-topic
LIMIT 1;
```

*Output:*

```json
{
  "value": {
    "SUBSTR": "aol.com",
    "email": "Jose.Hood@aol.com"
  }
}
```