>Seems like I am getting hits for data I do not want when using sql select statement. "Select pn,noun,cal_int from d:\zcalauth;
> where ALLTRIM(pn)=ALLTRIM(mpart_nbr) into cursor zcal"
>if mpart_nbr='44', I am getting matches on "44-10", "444", "445-9"
>only with SQL though :-(

In Sql Select comparison is controlled by SET ANSI command.

lcSaveAnsi = SET(" ANSI")
SET ANSI ON
Select pn,noun,cal_int from d:\zcalauth ;
            where pn = mpart_nbr into cursor zcal
SET ANSI &lcSaveAnsi

Should cure the problem