Re: Oracle Forms Search String

spencer wrote:

> i'm not at all familiar with Oracle Forms, so this
> may or may not be of help to you...
>
> in Oracle SQL, to represent a single-quote character
> within string (which is enclosed by single-quotes),
> simply use two single-quotes together...
>
> e.g. Mike's Bike ==in quotes=> 'Mike''s bike'
>
> HTH
>
> "Ira Rosen" <IROSEN1_at_email.mot.com> wrote in message
> news:3919A667.5A500A6C_at_email.mot.com...
> > I am trying to implement a search function within an Oracle
 Forms
> > application. The search string I would like to use contains
 some 'LIKE'
> > clauses for columns in an Oracle-based table. I want my search
 string to
> > contain single-quote characters. I realize this sounds
 trivial, but I am
> > unable to define a string such as: WHERE VALUE LIKE
 '%PATTERN%' because
> > Forms (or perhaps the server) assumes that the single-quote
 characters
> > in my search string are string delimiters. I've tried C/Unix
 tricks such
> > as preceding the single-quote character with '\' characters,
 but have
> > not had any luck. I want to implement this in a
 'WHEN-BUTTON-PRESSED'
> > trigger using the Set_Block_Property() built-in function.
> >
> > Thank you for your help.
> >
> > -Ira Rosen
> >
> >

[Quoted] Problem solved - thank you for your help.

-Ira Rosen Received on Thu May 11 2000 - 00:00:00 CEST