select query in sql-light dont work for me in android
<p>this code work for me:</p>

<pre><code>SQL = "SELECT _id,Fname,Lname,Phone,Car,CarNum,PicNum from MEN order by Lname,Fname";
.
.
public void update_list(String NN) {
       c = db.rawQuery(NN, null);
       startManagingCursor(c);

       String[] from = new String[]{"_id","PicNum","Fname","Lname","Car","CarNum" };
       int[] to = new int[]{  R.id._id,R.id.MyPic,R.id.Fname ,R.id.Lname,R.id.Car,R.id.CarNum };
       SimpleCursorAdapter notes = new SimpleCursorAdapter (this, R.layout.my_list, c, from, to);
       setListAdapter(notes);


setListAdapter(new SimpleCursorAdapter(this, R.layout.my_list, c, from,to) {
</code></pre>

<p>but if my query like this:</p>

<pre><code>SQL = "SELECT _id,Fname + Lname as Fname,Lname,Phone,Car,CarNum,PicNum from MEN order by Lname,Fname";
</code></pre>

<p>i got 0 in the column Fname.   </p>
