title: android sqlite delete query not working
body: <p>The following sqlite query does not delete IDs which starts with zero.</p>
  
  <p>Android Sqlite Table structure</p>
  
  <pre><code> String CREATE_TABLE_BUS = "CREATE TABLE " + TABLE_BUS + "("
                      + KEY_TID + " INTEGER PRIMARY KEY AUTOINCREMENT,"    
                      + KEY_BUS_NUM + " TEXT,"
                      + KEY_BUS_NAME + " TEXT,"
                      + KEY_FROM + " TEXT,"
                      + KEY_TO + " TEXT,"
                      + KEY_TYPE + " TEXT"
                      + ")";
  
              db.execSQL(CREATE_TABLE_BUS);
  </code></pre>
  
  <p>I kept BUS_NUM as text and not as int for some purpose.</p>
  
  <p>And this is the function I call to delete a row..</p>
  
  <pre><code>        public void Delete_Bus(String bus_num) {
              SQLiteDatabase db = this.getWritableDatabase();
  
              db.delete(TABLE_BUS, KEY_BUS_NUM+"="+bus_num , null);
                Log.e("deleting bus num", bus_num);
  
              db.close(); // Closing database connection
          }
  </code></pre>
  
  <p>This code works very fine when the code does not start with zero..</p>
  
  <p>It works for 76555 and not for 09877.  Whats wrong with my code</p>