SELECT SINGLE
FROM demo_expressions
FIELDS CAST( num1 AS CHAR( 20 ) ) AS col1,
CAST( numlong1 AS CHAR( 20 ) ) AS col2,
CAST( dec3 AS CHAR( 20 ) ) AS col3,
CAST( dats2 AS CHAR( 20 ) ) AS col4
WHERE id = 'X'
INTO @DATA(result).