Re: Help with complicated select statement

No Such Luck wrote:
> I have a table column, "filename", that stores the names of different
> types of files gathered from the web. Because the files are gathered
> from the web, some of the file names have URL encoded characters, i.e.,
> %20, %22, etc.
>

Looks at the web utility packages; there are escape_sc procedures that replace special escape sequences with their ASCII counter parts.

Oh - and Oracle has beaten you... they released your product as UltraSearch.

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...