# E061-05: LIKE predicate: ESCAPE clause

statement ok
CREATE TABLE TABLE_E061_05_01_01 ( ID INT PRIMARY KEY, A VARCHAR ( 255 ) );

query T
SELECT A FROM TABLE_E061_05_01_01 WHERE A LIKE 'foo' ESCAPE 'f'

statement ok
CREATE TABLE TABLE_E061_05_01_02 ( ID INT PRIMARY KEY, A VARCHAR ( 255 ) );

query T
SELECT A FROM TABLE_E061_05_01_02 WHERE A NOT LIKE 'foo' ESCAPE 'f'
