Selecting soft carriage return

  • Thread starter Thread starter John
  • Start date Start date
J

John

Hi

How can I select records which contain soft carriage return in one of the
fields?

Thanks

Regards
 
Hi John

If I understand you correctly, a "soft carriage return" is represented by a
carriage return, Chr(13), followed by a line feed, Chr(10).

So, you could use a query such as:

Select * from MyTable where SomeField like "*" & Chr(13) & Chr(10) & "*";
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Identify Carriage returns and line feeds on a table 3
Need to Identify Records with Carriage Returns within a Memo Field 6
Carriage return in memo field 5
Default formatting after carriage return? 5
Form recognizing hard carriage return 3
append text to end of multi-line textbox 9
Split data in field on character return 0
Delete carriage returns 6

Back
Top