>> select '~'||trim(A)||'~'||trim(B)||'~' as a from a;
>> +-------+
>> | A |
>> +-------+
>> | ~A~B~ |
>> +-------+
>
> Thank you...but it didn't work for me. It output a column of 1's. I'm
> actually not sure what the pipes and tildes are supposed to doing
> there, so perhaps I'm not adjusting for something I should be.

Post an example of the output you want.


$ mysql test -N -B -e "select col1,col2,col3 from tab"
Value1 Value2 Value3

$ mysql test -N -B -e "select concat(col1,col2,col3) from tab"
Value1Value2Value3


Regards
Dimitre