O'Reilly logo
  • Wiktor Bojanowski thinks this is interesting:

Expression

ProductName || 'sells for' ||
CAST(RetailPrice AS CHARACTER(8))

From

Cover of SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL, Fourth edition

Note

MySQL example:

SELECT CONCAT("TeamID of ", TeamName, " is ", CAST(TeamID AS CHARACTER(8))) FROM Teams;