SELECT Code + ' - ' + Name
FROM country
| Code + ' - ' + Name |
| ABW - Aruba |
| AFG - Afghanistan |
| AGO - Angola |
| AIA - Anguilla |
| ALB - Albania |
| AND - Andorra |
| ANT - Netherlands Antilles |
| ARE - United Arab Emirates |
| ARG - Argentina |
| ... |
| Concatenation Joining values together (by appending them to each other) to form a single long value. |