From the manual:
To search for employees with the pattern 'A_B' in their name:
SELECT ename
FROM emp
WHERE ename LIKE '%A\_B%' ESCAPE '\';
So you should be able to use another escape like:
SELECT ename
FROM emp
WHERE ename LIKE '%A#_B%' ESCAPE '#';
|
Results 1 to 2 of 2
Thread: Escape caracters in CONTAINS()Threaded View
|
Click Here to Expand Forum to Full Width |