Re: SELECT Error: ORA-01722: Invalid Number

this works. Thanks.

On Sat, 10 Mar 2001, Kirill Paliy wrote:

> Try to replace "+" with "||".
>
> "Chirag (Mark) Patel" <patelc_at_mcss.cas.mcmaster.ca> wrote in message
> news:Pine.LNX.4.10.10103091959560.10544-100000_at_mcss.cas.mcmaster.ca...
> > Can someone give me details about the following error I got at runtime:
> >
> > SELECT Error: ORA-01722: Invalid Number
> >
> > Thanks.
> >
> > ========
> > I was entering the following SQL QUERY in the datawindow painter in
> > Powerbuilder:
> >
> > SELECT .....
> > FROM .....
> > WHERE (requestor LIKE '%' + :input_requestor + '%');
> >
>
>
>
>
Received on Sat Mar 10 2001 - 15:12:51 CST