The strongest argument for having small lookup tables is this:
With an ongoing database, what if you want to change an existing salutation from, say...
(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...