Thanks Richard, the == works.

E.R.

>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