I really hope somebody can help me with this.
The database’s collation is SQL_Latin1_General_CP1_CI_AS and I can successfully output the pound sign with the following:

‘bcp “SELECT * FROM ##Temp” queryout ‘ + @ExportPathFile + ‘ -C RAW -c -t, -T’

Output:

However, this only works when the output is a few lines. If the output is large and thousands of lines, then the £ is getting replaced:

The same happens if I try -C ACP and -C 1252 for the code page setting. Can anybody explain this and suggest a solution?