franchb/replace_crlf.sql

Created January 29, 2018 09:24

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/franchb/f4adb8624e88c7040719954500bf7818.js"></script>
Save franchb/f4adb8624e88c7040719954500bf7818 to your computer and use it in GitHub Desktop.

Download ZIP

SQL CRLF / endline issue

Raw

replace_crlf.sql

REPLACE(REPLACE(REPLACE(mycolumn, CHAR(9), ''), CHAR(10), ''), CHAR(13), '') as 'mycolumn'

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment