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