Hi.
I have the below query which I am trying to execute from a c# code using the process function.
BCP "SELECT ('"' + replace(ColName, '""', '""""') + '"') as commens
FROM TableName " queryout "FilePath" -T -S ServerName -d DBName -b 500 -c -C 65001 -t~
Since the command contains + , the BCP is failing with error : Copy direction must be either 'in', 'out' or 'format'. I am not able to use QuoteName function for the column, as it is of type varchar(max) and fails with error string or binary data would be truncated.
How to use + in BCP for the query ?
Thanks