2 Replies Latest reply on May 29, 2009 4:53 PM by de5a1n7

    SQLite, problem with parameter




      Does anyone know what's wrong with the following sql statement?


      var GetItemByNameSql:String = "SELECT id FROM items WHERE name LIKE '%:name%'";


      I've got an error saying that parameter :name is not in the SQL.


      when i remove the % symbol it is fine but then the statement will only return the whole word match.


      Does this mean i cannot use % together with parameter?