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 :-(
"Build a man a fire, and he's warm for a day.
Set a man on fire, and he's warm for the rest of his life."