Access 数据库:Select语句中,字段内容竟然区分大小写,请问如何做到用户名不区分大小写,密码区分大小写呢?
原来的语句是这样的,对大小写敏感
strSql = "Select * From Member Where MemberNumber Like '" & UserName & "' And Password='" & Password & "')
改为这样也一样,还是对大小写敏感,请问如何做到用户名大小写都可以呢?
strSql = "Select * From Member Where UCase(MemberNumber) Like '" & UserName & "' And Password='" & Password & "'“