Yes, FlameRobin which I use needs the SET TERM^^ ; and SET TERM ; ^^ to make your statement work. That too has the same result now as the SP route you had suggested.
I do see that we have come a full circle and have the need to provide fixed column names. But all is not lost, I think I can use the output in the front end app to have an efficient cross tab created without knowing what cCode are created. Thanks a lot. Kind regards Bhavbhuti
