microsoft:microsoft_sql_server:sql:find:find_line_break_and_carriage_return

Table of Contents

Microsoft - Microsoft SQL Server - SQL - Find - Find Line Break and Carriage Return

Microsoft - Microsoft SQL Server - SQL - Find - Find Line Break and Carriage Return

Create Test Table

CREATE TABLE test(id INT, name VARCHAR(100));

Insert some sample data

INSERT INTO test 
VALUES(1,'Aamir\n'),
(2,'shahzad'),
(3,'Robert\r\n'),
(4, 'This is \n test');

Return all the values which has \n or \r or both of them

SELECT * FROM test WHERE
name LIKE '%\n%'
OR name LIKE '%\r\n%';

microsoft/microsoft_sql_server/sql/find/find_line_break_and_carriage_return.txt · Last modified: 2021/08/05 14:41 by peter