ToString



Returns the number as a string, so that + concatenates it instead of adding it.

String ToString(Numeric value)

round-pushpin Returns 'Prefix1050Suffix'.
SELECT 'Prefix' + 10 + ToString(50) + 'Suffix' as Result FROM Single