best solution for me was to use char(ASCII number) for example: char(39) is ' query example: select * from table replace (column, char(36), " ")="value" replace with space or anything, and compare it as such. hope this helps!!!! <3