Hello Ed and Costas Thanks for the Info. You had one key word which solved the problem (Trim). In my case it was alltrim

the following code Works Fine

select process.flow_no;
from process process, yarn yarn;
where yn_date between start_date and end date and;
yarn.yn_procsys==process.proc_name;
into cursor query

This code produces the error 112 Invalid key length, the only difference is the alltrim!

select process.flow_no;
from process process, yarn yarn;
where yn_date between start_date and end_date and
alltrim(yarn.yn_procsys) == alltrim(process.proc_name);
into cursor query


Thnaks for your help

-Allan Privott