# LPAD

```
LPAD(strExpr, lengthExpr, padExpr)
```

Prepends the value of *padExpr* to the value of *strExpr* until the total length is *lengthExpr.*

Available in:

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

*Sample code:*

```sql
USE `kafka`;
SELECT 
    LPAD(email, 50, ' '), 
    email 
FROM users-topic
LIMIT 1;
```

*Output:*

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