where clause. I haven't tried it here, but WHERE
dbms_lob.INSTR(UPPER(section.text), UPPER('abc'))>0 may work fine.
-----Original Message-----
From: Deanna Schneider [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 15, 2003 9:39 AM
To: CF-Talk
Subject: Re: Constrain on a blob
You should be able to do this (at least it works on clobs)
SELECT header FROM section WHERE dbms_lob.INSTR(section.text, 'abc')>0
This performs a case-sensitve LIKE search. I've yet to find any way to do a
case-insensitive LIKE search.
-Deanna
----- Original Message -----
From: "Sean McCarthy" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, October 14, 2003 6:07 PM
Subject: Constrain on a blob
> I get and 'inconsistent datatype' error when I try to:
>
> SELECT
> title
> FROM
> myTable
> WHERE
> myBlob = 'abc'
>
> Is it possible to constrain on the information in a blob. Optimally I
would
> like the ability to do a 'like %foo%'
>
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
