Season's greetings
Hello,
I don't particpate to the forums anymore because I can't figure out how to identify the interesting (for me) threads, sorry... But let me wish you, in my usual way,
SET HEA OFF
SET COLSEP ''
COL X FOR A1
SELECT MAX( CASE WHEN x = 1 THEN CHR( y ) END ) x
, MAX( CASE WHEN x = 2 THEN CHR( y ) END ) x
, MAX( CASE WHEN x = 3 THEN CHR( y ) END ) x
, MAX( CASE WHEN x = 4 THEN CHR( y ) END ) x
, MAX( CASE WHEN x = 5 THEN CHR( y ) END ) x
, MAX( CASE WHEN x = 6 THEN CHR( y ) END ) x
, MAX( CASE WHEN x = 7 THEN CHR( y ) END ) x