Comapring text with # in them

  • Thread starter Thread starter sbsmc
  • Start date Start date
S

sbsmc

I want to compare two text fields. Some of the records have "#" in them.
When I use [field1] not like [field2] I am having problems comparing records
with "#".

Thank you.

sbsmc
 
I want to compare two text fields. Some of the records have "#" in them.
When I use [field1] not like [field2] I am having problems comparing records
with "#".

Thank you.

sbsmc
Click to expand...

The LIKE operator treats # as a wildcard for a numeric digit. If
you're doing a comparison to see if the fields are unequal, don't use
NOT LIKE; instead use the <> operator which means "is not equal to".
 
Back
Top