title: Android Sqlite concat two columns
body: <p>I have made the concatenation so far, but in the results, it displays </p>
  
  <pre><code>UncleSam.
  </code></pre>
  
  <p>What I want to do is to put a space between the two columns so the result would be </p>
  
  <pre><code>Uncle Sam.
  </code></pre>
  
  <p>This is the code I'm working on:</p>
  
  <pre><code>   public Cursor getAllPatients()
  {
      Cursor localCursor = //  
              this.myDataBase.query(DB_TABLE, new String[] { 
                      KEY_ID, KEY_FNAME + "||" + KEY_LNAME, KEY_DIAGNOSIS, KEY_LASTFFUP }, null, null, null, null, null);
      if (localCursor != null)
        localCursor.moveToFirst();
      return localCursor;
  }
  </code></pre>
  
  <p>from DBHelper.java</p>
  
  <p>and</p>
  
  <pre><code> Cursor cursor = dbHelper.getAllPatients();
      String[] data = new String[]{
              DBHelper.KEY_FNAME + "||" + DBHelper.KEY_LNAME, DBHelper.KEY_DIAGNOSIS, DBHelper.KEY_LASTFFUP};
      // 
      int[] to = new int[] {R.id.fullname, R.id.diagnosis, R.id.lastffup};
  
      dataAdapter = new SimpleCursorAdapter(this, R.layout.custom_row, cursor, data, to, 0);
  </code></pre>
  
  <p>from my MainActivity.</p>
  
  <p>Any help will do. Thanks.</p>