SQLTeam.com | Weblogs | Forums

Replacing character in several columns?


I have to export data from a table to a text file where the delimiter is a pipe (|). I have configured SSMS to do this. This data is then imported into a reporting tool but the import is falling over because several columns have a pipe in them (mainly descriptions).

Is there a way I can "clean" the data in my table to strip out any pipes and replace them with, say, a space?

Many thanks.

one idea is before exporting replace in the columns


Put the data in quotes