SQL remove carriage return

 This video shows you how to use replace with regular expressions to strip out carriage returns and remove line feed in your SQL code

using standard replace functionality

This technique can be used fairly regularly and is one of our favourite timesavers