Treat LF as CR LF

ioani

Hi,

I have a table that has a nvarchar column. This column rows contains text on many lines. When I compare the table from different DBs some rows have new lines coded as CR LF other as LF. How can be made LF to be treated as CR LF so that two identical rows not to be treated as different because of different new lines?

Thanks

Manfred.Castro

Unfortunately there is not an option such that two identical rows not to be treated as different because of different new lines
There is an existing feature request you may want to vote for.
http://redgate.uservoice.com/forums/147 ... roject-opt
These forums are actively monitored by our development team and allow our users to reuest features and vote on them.
If a feature receives a significant amount of votes or is deemed to have merit development may include the feature in a future release.