tyler.style@gmail.com wrote:

> I have a decidedly ugly problem...I really want output with NO
> delimiters whatsoever for specialized legacy systems reasons. Can
> anyone tell me if it's possible to get mysql to return results without
> the tabs? On a WindowsXP box, I am currently using:
>
> mysql -uexport -pxxxx --force -N hh < c:\batch\getFedexFrom.sql >
> P:\ship\FEDEX\fedexFROM.txt
>
> where getFedexFrom.sql is simply
>
> select * from hh.fedexfrom
>
> I'd rather do it all from mysql if possible, rather than having to do a
> 2nd sweep with some kind of awk.
>
> Any suggestions would be much appreciated!
>
> Tyler Style
>
>
>
> tyler AT
> healthy habits web
> DOT
> com
>

select '~'||trim(A)||'~'||trim(B)||'~' as a from a;
+-------+
| A |
+-------+
| ~A~B~ |
+-------+



--
Michael Austin.
DBA Consultant