Oracle Text Index and wildcards

[Quoted] [Quoted] how can I search for '%' and '_' in an Oracle Text Index. I tried with escape characters \ and {} but I always get all records of the table

example :

SELECT DISTINCT(login)

    FROM account
    WHERE CONTAINS( index_column1, '( %\%% ) WITHIN name')>0

I also tried to define the % and the _ character as a printjoin, but also without any effect.

Any idea ?

Peter Received on Wed Feb 04 2004 - 14:46:49 CET