I am connecting to a SQL server table with a space in the table name (say, [my table]) via a CursorAdapter. How should I write the UpdateNameList property of the CursorAdapter.

I tried quoting the table name with a pair of square brackets like "id [my table].id, num [may table].num". However the CursorAdapter failed to update the master table with the changes in the cursor.

Any idea?