>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
--sb--