>Sorry, but this was too easy - and no one got it > >COPY TO TYPE DELIMITED WITH , > >It produces what you asked for. > >Hope it helps, > >James Jernigan >Nashville, TN
James, Might be that you got it wrong ? Reread the thread. Just replacing text delimiter with another character wouldn't mean clearing quotes. With your approach just one character field table would output as 3 fields per row. Cetin
