Identify Carriage returns and line feeds on a table

[Lina]

Hello,
I have a table that can potenitally contain carriage returns and/or
line feeds in the fields

I want to identify all records that have carriage returns

I want to create a query but how do i identify the CRs and LFs?

Thanks!

 

[Ken Snell \(MVP\)]

SELECT *
FROM TableName
WHERE FieldName Like "*" &
Chr(13) & Chr(10) & "*";

 

[Duane Hookom]

Since the carriage returns and line feeds might be present individually, I
would use:
SELECT *
FROM TableName
WHERE FieldName Like "*" &
Chr(13) & "*" OR FieldName Like "*" & Chr(10) & "*";

 

[Lina]

thank you very much!