Netezza is able to find records when using the LIKE operator when the first character contains a backslash character. But when subsequent characters contain a backslash character, it cannot. How can I correct this?
Result set has records:
SELECT * FROM TABLENAME WHERE PATH LIKE '\some_path%'
Result set has 0 records:
SELECT * FROM TABLENAME WHERE PATH LIKE '\some_path\%'