Column seperator question

[pjb]

When using the column separator option -s on the isql command line, is there a way to force the first separator character to either precede the first column, or to follow the the first column? In other words, if I use -s'|', the output would look like:
|column1|column2|column3

Is there a way to have it like this:
column1|column2|column3|

 

[gregsimpson]

You could always do something along the lines of

SELECT
'|',
Column1,
'|',
Column2
'|',
FROM
TEST_TABLE