>Still confused. I was referring to uses of "=" within SELECT statements. I had a statement that looked like:
>
>Select * from Mytable left join PartTable on MyTable.part = PartTable.part
>
>Doing this, I got multiple records when I had entries like "KP3 ", "KP31 ", "KP32 " in PartTable. Is this controlled by SET ANSI or SET EXACT? The documentation states:
>
>
Unlike SET ANSI, SET EXACT does not apply to Visual FoxPro SQL commands. For more information, see SET ANSI Command.In SQL the string comparison is controlled by SET ANSI, anywhere else by SET EXACT.
--sb--