(Having a separate primary key for a tiny table seems like a really odd thing to do... If it's only a handful of values, why not just store the real...
No you are not wrong, Access SQL is not case sensitive. T-SQL can be if you use the right syntax (Collate I seem to recall) but otherwise is also not...
I'm not sure what you mean or what the mystery is. Access sql is not case sensitive, so your query doesn't care if the field contains L or l. If you...
weird sql syntax - please specify what database you are using that uses that syntax or provide your actual sql. But my guess would be you have other...