SQL Server 7.0 Where = problem

I have a SQL Server 7.0 table with char(200) fields. If a row has a ? in it and another row has a ? in it, a select * from table where field = ‘?’, will return both rows even though ? is ASCII code 232 and ? is ASCII code 200. Why does this occur?