| Select | Select | Select | string-length | substring-before 'n' | substring-after 'n' | concat | contains 'i' |
|---|---|---|---|---|---|---|---|
| 1 | Nancy | Davolio | 5 | Na | cy | Nancy Davolio | false |
| 2 | Andrew | Fuller | 6 | A | drew | Andrew Fuller | false |
| 3 | Janet | Leverling | 5 | Ja | et | Janet Leverling | false |
| 4 | Margaret | Peacock | 8 | Margaret Peacock | false | ||
| 5 | Steven | Buchanan | 6 | Steve | Steven Buchanan | false | |
| 6 | Michael | Suyama | 7 | Michael Suyama | true | ||
| 7 | Robert | King | 6 | Robert King | false | ||
| 8 | Laura | Callahan | 5 | Laura Callahan | false | ||
| 9 | Anne | Dodsworth | 4 | A | ne | Anne Dodsworth | false |