Re: Using LIKE with a LONG field

From: Brad Pybus <brad_pybus7zwq_at_hotmail.com>
Date: Tue, 20 Aug 2002 15:51:31 -0500
Message-ID: <8Zx89.1233$Bd4.10425@dfw-service2.ext.raytheon.com>

I had this same issue a few months ago. You can't use LIKE with long fields. I ended up having to use Oracle Intermedia (Oracle 8i) but if your using Oracle 9i its called Oracle Text. You have built a context index and then create an SQL query using the "contains" keyword.

"Kevin Blount" <kevin_at_questionmark.com> wrote in message news:1511a6a5.0208201240.9819194_at_posting.google.com...
> I'm trying to search through a LONG field which contains the
> description of an item in my database. However, when I use the
> following SQL Query I am told that I have 'inconsistant datatypes'
> when I run the Query (in ASP)
>
> SELECT * FROM resources_objects WHERE resource_object_description
> LIKE '%string%'
>
> Any idea how I can use LIKE with a LONG field? I'm pretty certain it's
> this LONG field type that's caussing the issue, as the same SQL Query
> with a different field type (VARCHAR2) works fine.
Received on Tue Aug 20 2002 - 15:51:31 CDT