vsshs/newlinevalues.sql

Last active November 13, 2015 15:53

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/vsshs/f13bf2459e615e5a90a9.js"></script>
Save vsshs/f13bf2459e615e5a90a9 to your computer and use it in GitHub Desktop.

Download ZIP

select values with newline symbols

Raw

newlinevalues.sql


	DECLARE @NewLineChar AS CHAR(2) = CHAR(13) + CHAR(10)
	SELECT *
	FROM <tablename>
	WHERE <fieldname> like '%'+@NewLineChar

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