Identify Carriage returns and line feeds on a table

  • Thread starter Thread starter Lina
  • Start date Start date
L

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!
 
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) & "*";
 
Back
Top