-> Write table data to a text file? How? <-

To all,

What's the best way to write data out to a text file: comma-delimited, tab-separated, or fixed length? I basically need to write out a table into a format usable by other RDMSs/applications. I'm looking for something similar to the Bulk-Copy Program from Sybase or Microsoft SQL Server.

Thanks in advance!

-- 
 Les Gainous, lesgainous_at_earthlink.net

 Visit my web page at
      http://home.earthlink.net/~lesgainous

 Looking for a Client-Server job in California?
      http://home.earthlink.net/~lesgainous/jobs.html