SELECTFORMATMESSAGE('This is the %s and this is the %s.', 'first variable', 'second variable') AS RESULT;
Result:
RESULT|
-----------------------------------------------------------+
This is the first variable and this is the second variable.|
Code:
SELECT--** MSC-WARNING - MSCEWI4065 - FORMATMESSAGE WAS CONVERTED TO CUSTOM UDF FORMATMESSAGE_UDF AND IT MIGHT HAVE A DIFFERENT BEHAVIOR. **
FORMATMESSAGE_UDF('This is the %s and this is the %s.', ARRAY_CONSTRUCT('first variable', 'second variable')) AS RESULT;
Result:
RESULT |
-----------------------------------------------------------+
This is the first variable and this is the second variable.|
Related EWIs
MSCEWI4065: FORMATMESSAGE function was converted to UDF.