Exporting to Shapefile

[VolkerBarth]

If I have a table that has some spatial fields in it (i.e. a list of points geometries), is there anyway using ISQL to do something like

SELECT * from address_table ; OUTPUT TO c:\\testit\\address_table.sh FORMAT SHAPEFILE ;

I know it's real easy to LOAD in spatial data but what are the options for creating a shapefile in the way out? Is this something better done with ESRI API tools etc?

Thanks!

[VolkerBarth]

Do you need the output to be a shapefile, or would other spatial data file formats do, as well? ESRI shapefiles seem to be the only data format not supported to export to.