yall came with the solution for me. Who gets the 10 points? :-)


>Actually, ANSI provides SQL standards, too. SET EXACT doesn't affect the SQL Select command.
>
>>YES, THEY BOTH(ansi and ==) did the trick. But what I can't understand is that I tried the exact being ON and made no difference. Other thing, I thought ANSI was a national standards for characters?????????????
>>
>>
>>>Timothy,
>>>
>>>Use "==" sign:
>>>
>>>

>>>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 :-(