>Now I'm lost. :(
>
>Why is it that R, R1, R2 is selected when I do "select * from table where ckey="R".. ")
>
>???

Evelyn,
With default "set ansi off":

"John" = "J"
"John" = "Jo"
etc. IOW it means begins with. To fix the issue use == instead of =.

select * from table where ckey=="R" ...

Cetin