Thanks Frank....

I was afraid of that...parsing the data to look for delimiters looks to be the only way ...

that is not a double quote in front of dog its two single ticks...

I dont want the tick at the end of the stream that would make the data invalid...

Sorry...

Here is how the insert ends up looking because the @parameter passes the data to the dynamic insert statement..

Insert into table ('col', 'col') Values (''dog', 'cat')

See right before the dog...

Frank:

Would that always insert a tick ....this has only occurred once so far...if it always inserts a tick then the data would not be correct..

My insert statement passes the VALUES...

Here is kinda what I want to do....(I know this doesnt work)...can someone help me get it right..

Create function GetAllData

(@filterid uniqueidentifier)

RETURNS table

AS

RETURN {select statement that uses all the tables...

Thanks for your input I realized the problem...I had to also include the Dbname.table.columnname in the where clause..

I tried it a again:

use master

exec xp_cmdshell 'bcp "select * from dbname.owner.table where checkbit = 0" queryout e:\products.txt -c -Sserver -Usa -Ppassword'

I get as an error the format for writing...