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

[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

 

[golfinray]

In your query criteria, put Not like <br />

 

[EllenM]

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

 

[golfinray]

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 />""

 

[Michel Walsh]

Have you tried

NOT LIKE "*<br />*"




Vanderghast, Access MVP

 

[EllenM]

Thanks, Michel. That one works. :-D

Have you tried

NOT LIKE "*<br />*"




Vanderghast, Access MVP

 

[John W. Vinson]

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

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.