Fuzzy search

Discussion in 'Questions (Windows Mobile)' started by lijingtong, Aug 2, 2008.

  1. lijingtong

    lijingtong Member

    Sub App_Start
    Form1.Show
    con.New1
    cmd.New1("",con.Value)
    con.Open("Data Source = " & AppPath & "\pinyin.db")
    Cmd.CommandText = "select * from pinyin where code='" &"a" & "'"
    cmd.ExecuteTable("table1",500)
    End Sub

    Result: "a"
    how to do it can the result is "ai" "dai" "aaa"……
     
  2. Erel

    Erel Administrator Staff Member Licensed User

    Code:
    cmd.CommandText = "SELECT * FROM pinyin WHERE code LIKE '%a'"
     
  3. lijingtong

    lijingtong Member

    thank you:)
     
Loading...
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice