Ed,

I understand what you're saying here, and why, but would it right to say that if E.R. already has an app that's basically done, this may require him to re-test most of his app, since it's such a low level change.

It may be more expediant to just change the select's where clause to:
where alltrim(ID) == '123'

It accomplishs his stated purpose and has no impact on other existing comparrisons....although he may later find out that this same hole exists elsewhere in his app....If that's the case then I too would reccomend the SET ANSI be changed.

Rick

>>I'm doing select on a table with an ID that has 123,123A,123B. When I select * from table where alltrim(ID) = '123' I also get the records for 123A and 123B. Set exact doesn't effect it, what am I missing?
>>
>>TIA,
>>
>>E.R. Gilmore
>
>SET ANSI ON/OFF