Re: SELECT Error: ORA-01722: Invalid Number

the datatype is varchar

On Sat, 10 Mar 2001, Brian Dick wrote:

> What's the data type of "requestor"? It had better be a char or varchar. The
> LIKE operator is for strings.
>
> "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:02:15 CST