SQL LIKE contaning point?

I have similar values in database:

U.S
EE.UU etc. these values are not static but dynamic!!!

How to tell SQL to find exact match and skip or allow points?

I don’t wanna use anything like this:

like ‘%word%’

WHERE column = 'U.S' OR column = 'EE.UU'

Thanks I think I need SELECT REPACE but not sure how to use it.

why do you need SELECT REPLACE if you want an exact match?

I am taking value from URL what loos like this: ee uu and SQL contains EE. UU.

ah, okay

WHERE REPLACE(column,'.','') = 'US' OR REPLACE(column,'.','') = 'EEUU'

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.