> 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.