>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 :-(
Tim,
As suggested == is the right answer. Wanted to note that using == in SQL you don't need any rtrim() functions. ie: Assuming no spaces on left these are equivalant :
where myField == lcMySearch
where alltrim(myField) == alltrim(lcMySearch)
For SQLs use 'set ansi' if needed not 'set exact'.
Cetin