Is it possible to make a SELECT statment case-sensitive? For example, is it possible to have a statment like
where, if txtCountry.text = 'France', the recordset would return 'France' but not 'FRANCE'?Code:rsCountry.Open "Select * From Countries Where COUNTRY = '" & txtCountry.text & "'", myCN, adOpenKeyset, adLockReadOnly




Reply With Quote