Re: blank in query - cannot return results

​It works.

WITH vals (v) AS ( VALUES ('Abc, test'::text) )

SELECT *

FROM vals

WHERE v ILIKE '%Abc, test%'​

If you are expecting a match and are not getting one that you need to look at your data and figure out where you misunderstanding lies.​

​David J​

​P.S.​

​"

​"

​Removing the space and putting a "%" in in place simply means that the space was optional, and since it now matches, is not present in the values that appear in this query but not the one with an explicit space.

Note that there are different kinds of spaces...