# Joining Strings Using The Piping Operator
__*PIPES_AS_CONCAT SQL mode schema*__
+ For example:
  + `SET sql_mode=PIPES_AS_CONCAT;`  
  + `SELECT 'Welcome'||' to '||'TiDB!';`  
```10
tidb> set sql_mode=~!@PIPES_AS_CONCAT@!~;
Query OK, 0 rows affected (0.00 sec)

tidb> select 'Welcome'||' to '||'TiDB!';
+----------------------------+
| 'Welcome'||' to '||'TiDB!' |
+----------------------------+
| Welcome to TiDB!           |
+----------------------------+
1 row in set (0.00 sec)
```

------------------------------------------------------------
By default, || is OR.
```
tidb> select 'Welcome'||' to '||'TiDB!';
+----------------------------+
| 'Welcome'||' to '||'TiDB!' |
+----------------------------+
| 0                          |
+----------------------------+
1 row in set, 3 warnings (0.00 sec)

tidb> set sql_mode=PIPES_AS_CONCAT;
Query OK, 0 rows affected (0.00 sec)

tidb> select 'Welcome'||' to '||'TiDB!';
+----------------------------+
| 'Welcome'||' to '||'TiDB!' |
+----------------------------+
| Welcome to TiDB!           |
+----------------------------+
1 row in set (0.00 sec)
```