ToString
Returns the number as a string, so that + concatenates it instead of adding it.
String ToString(Numeric value)
SELECT 'Prefix' + 10 + ToString(50) + 'Suffix' as Result FROM SingleSELECT 'Prefix' + 10 + ToString(50) + 'Suffix' as Result FROM Single