How can I export from a sql table to a text file with | (pipe) as the delimiter and NULL as nothing (eg || (pipe pipe) not |NULL| (pipeNULLpipe)). I will want to do this for multiple tables and so I
don't want to set up the format for each column. I can't do IsNull within sql because they are views and end up coming out with odd results.
At the moment I use sql batch exporter BCP to export to a text file delimited with pipe |
But if I use my case mgmt to import this it always falls over at a line with a NULL (see txt with NULL)
