Dear Experts!
I have 02 tables:
table1
phyto_no
PCKS/33857/-06-07
PCKS/33858/-06-07
PCKS/790/06-07
PCKS/1381/06-07
PCKS/1487/06-07
PCKS/2032/06-07
PCKS/306/-06-07
PCKS/308/-06-07
table2
phyto_no
PCKS/33857/-06-07
PCKS/33858/-06-07
PCKS/790/06-07
PCKS/1381/06-07
PCKS/1487/06-07
PCKS/2032/06-07
PCKS/306/-06-07
PCKS/308/-06-07
PCKS/01/790/06-07
PCKS/01/1381/06-07
PCKS/01/1487/06-07
PCKS/01/2032/06-07
etc...
I have problem in matching charcter strings. i use the following select query
SELECT * from table1,table2 WHERE UPPER(table1.phyto_cert) = UPPER(table2.phyto_cert) INTO CURSOR cst
Result are as follows:
PCKS/790/06-07
PCKS/1381/06-07
PCKS/1487/06-07
PCKS/2032/06-07
while other phyto nos are missings.i think there is a problem in converting strings with characters like /,-,: etc.
plz help me!
naveed