Why if I filter (WHERE=) a row to be equal to a value then in the results I get different values?

I made a view in IBM, then I linked my ms-access 2003 to that view and made a query like this:

select * from my_view where a="hey"

but in the results I ge开发者_如何转开发t a="hey" as well a="asd"

What may I do?

Use single quotes in literal SQL strings.

SELECT * FROM my_view WHERE a = 'hey'