How to find data with Carriage Return in string in SQL Server


You are working as SQL server DBA and you have a table Test with column Name , you need to find if Name column contain any data which has carriage return, how would you find string with carriage return in SQL Server?


You can use below sql statement to find our carriage return in SQL Server.

Select Name From dbo.Test
where Name like '%'+char(13)+'%' or Name like '%'+char(10)+'%'