Search db table column for a return or linefeed

select * from address a
where patindex( ‘%’+CHAR(13)+CHAR(10)+’%’,a.address2) >0

select count(*) from address a
where patindex( ‘%’+CHAR(13)+’%’,a.address1) >0

10 = linefeed
13 = carriage return
9 = tab
8 = backspace