# **BIN()**

## **Function Description**

``BIN()`` converts *N* to binary string form. where *N* is a ``longlong (BIGINT)`` number. If *N* is *NULL*, ``NULL`` is returned.

## **grammar**

```text
> BIN(N)
```

## **Parameter definition**

| Parameters | Description |
| ---- | ---- |
| N | Required parameters. UINT Type |

## **Example**

```text
> SELECT bin(1314);
+-----------------+
| bin(1314) |
+-----------------+
| 10100100010 |
+-----------------+
1 row in set (0.01 sec)

> select bin(2e5);
+-------------------------+
| bin(2e5) |
+-------------------------+
| 110000110101000000 |
+-------------------------+
1 row in set (0.00 sec)
```