0

hi
when i'm giving some string to search in the data base, ms access, that search is going to be ignoring case. i want case sensitivity. how..?
ex: if i would like to search for the word "Done", if there is no that word, and "DONE" is available in the database, then it is treating both as same. how to avoid this.

2
Contributors
3
Replies
12
Views
4 Years
Discussion Span
Last Post by tinstaafl
0

For q As Integer = 0 To spl.Length - 1

            s = "select san from dictionary where tinglish ='" & spl(q) & "'"


        cmd = New OdbcCommand(san, cn)
        dr = cmd.ExecuteReader()
        If (dr.Read()) Then
            singl(q) = dr.GetString(0)
        End If
        nsinglishstring = Join(singl)
    Next q
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.