Re: Oracle Forms Search String

[Quoted] 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
>
>
Received on Thu May 11 2000 - 00:00:00 CEST