Find data that does not contain "<br />"

  • Thread starter Thread starter EllenM
  • Start date Start date
E

EllenM

Hello,
I need to find data that does not contain a "<br />".

For starters I tried to fine the data that does contain "<br />" and was
unsuccessful. I assume I need some sort of escape character.

Thanks in advance for your help,
Ellen
 
Hello Milton,
It tells me that "The expression you entered contains invalid syntax". I
believe I need some sort of escape character to make it work.

Ellen
 
If it is text, you would have to put Not Like "<br />" if it already has
quotes you might have to try Not Like ""<br />""
 
Hello,
I need to find data that does not contain a "<br />".

For starters I tried to fine the data that does contain "<br />" and was
unsuccessful. I assume I need some sort of escape character.

Thanks in advance for your help,
Ellen
Click to expand...

You need to use the LIKE operator with some wildcard characters; the *
wildcard means "match any string". Try a criterion in your query

NOT LIKE "*<br />*"

This will find (and reject!) records where the field contains any string of
characters followed by <br /> followed by any other string of characters. Note
that the whole shebang has to be in quotemarks to be recognized as a string
criterion.
 
Back
Top