0 Replies Latest reply on May 10, 2010 3:19 PM by Mara G.

    Search with first letters

    Mara G.

      hi!

       

      I'm trying this for my search:

       

      query.text = "SELECT * FROM people WHERE upper(surname) LIKE :searchsurname OR upper(name) LIKE :searchname";

       

      and it works, but I would like to type just a few letters and get results so I tried this syntaxis but it doesn't work

       

      query.text = "SELECT * FROM people WHERE upper(surname) LIKE '%:searchsurname%' OR upper(name) LIKE :searchname";

       

      Hope someone can help me.

      Thanks and regards!

      Mara.-