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...