# IF Function
__*IF function*__
+ **`IF(cond, then_return, else_return)`**  
  + For example: **`SELECT IF('ABC' > 'aBC', '+++', '---');`**   
```
tidb> SELECT IF(~!@'ABC' > 'aBC'@!~, '+++', '---');
+---------------------------------+
| IF('ABC' > 'aBC', '+++', '---') |
+---------------------------------+
| ---                             |
+---------------------------------+
1 row in set (0.00 sec)
```

------------------------------------------------------------
- **`IF()`**  Build if/else