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]
