Re: Oracle Text Index and wildcards

mtg wrote:

> Hi,
>
> 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

Can't say that it will work but try a variation on this:

SELECT *
FROM wildcard
WHERE test LIKE '%\%%' ESCAPE '\';

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)