SQL
Strings with Special Characters
To use special characters in string, use [escape string literals](#docs:sql:data_types:literal_types::escape-string-literals) or [dollar-quoted string literals](#docs:sql:data_types:literal_types::dollar-quoted-string-literals). Alternatively, you can use concatenation and the [`chr` character function](#docs:sql:functions:char):  
```sql
SELECT 'Hello' || chr(10) || 'world' AS msg;
```  
<!-- This output intentionally uses the duckbox formatter -->  
```text
┌──────────────┐
│     msg      │
│   varchar    │
├──────────────┤
│ Hello\nworld │
└──────────────┘
```