return a column as a row

[TRYP]

how can i return a 1 column result set as a multi-column single row ????

tryp

 

[chiph]

In your select statement, include as many pseudo-columns as you need.
[tt]
select MyColumn, ' ', ' ', ' ' from MyTable where MyKey = MyKeyValue;
[/tt]

Chip H.