And recent versions of Sybase will let you bcp from a view, which pretty much lets you extract any data you want from a table (or collection of tables) into a bcp file.

Michael