I am trying to use BCP command in a C# console application.
The sql query is as below:
BCP "SELECT 1 as First, [IDENTITY], QUOTENAME(columnName,'""') from tablename" queryout "C:\Data\FILEname.del" -T -S Server -d DBInstance -b 500 -c -C 65001 -t~
since the query contains  , the bcp returns no rows. Directly running this in SQL, rows are shown in results.
How to fix this ?