Antw: VARCHAR variable in where clause

Hi NG

I just found the problem.

PART NR is the same as part nr of course.

so renaming PART NR into PART NR TO SEARCH FOR is solving the problem...

Peter

>>> Peter Jenny<Peter.Jenny_at_cedes.com> 20.11.2003 15:31:29 >>>

Hi NG

How do I have to use a VARCHAR2 variable in a where clause. I could not find an example.

PART NR VARCHAR2(20);
myPartId NUMBER()20;

PART NR := '101 189';
select part id into myPartId from part where part nr = PART NR; -- not working, hwo to do ?

How do I have to "escape" the PART NR, that it will be:

where part nr = '101 189'

Thanks
Peter

--