I tried using all the variations of -r "/n" -r/n or -r"square" -r"0x0D" -r0x0D with spaces without spaces but still 0 rows copied. maybe the bulk insert might be better...

Its number 10 (lf) character as i used the statement you provided and got the character number.

Thank you for taking the time to answer my question. i tried both the approach for the BCP line command modifications as you mentioned by adding the square symbol in...

Hi and thanks for helping out a newbee... i have cleaned my query down to what i need however i am sorta new to sql so i dont know how...

Thank you David,

i figured it out...the error was due to the fact i had where in the query twice which was unnecessary.

and a few syntax as the error mentioned.

thanks again.