Trying to write a query with LIKE and a variable with content
<pre><code>int FROMcountryChooseId=10;
String ToConvert = (EditView)findViewById(R.id.NumberEditView); 
String query="SELECT DISTINCT trim(Country.Country) FROM Country,DCI WHERE Country.CountryN°= "+FROMcountryChooseId+ " AND Country.Country LIKE "+"'&amp;ToConvert&amp;'"+" AND DCI._ID=Medicaments.DCIN° ORDER BY DRUG ASC LIMIT 1000;";

myDataBase.rawQuery(query, selectionArgs)
</code></pre>

<p>Hi i don't know how to make my query recognize wordToConvert as variable that content something and not just a String.</p>

<p>Any idea how to do that??</p>

<p>thanks for helping    </p>
