Member Avatar for baabjitvk

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
  • 95 Views
  • 12 Hours Discussion Span
  • Latest Post Latest Post by tinstaafl
Member Avatar for tinstaafl

Show the code you're using to do the search.

Member Avatar for baabjitvk

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
Member Avatar for tinstaafl

Here's a thread that discusses this topic and contains a solution.

Edited by tinstaafl
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.