>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