Refer to Alexeder's code as belows
"ORDER BY name ASC" it can used only English, If I need to test my language(Thai) ,How to code?
B4X:
'SQL query based on the search text
Dim DR As ResultSet = sql1.ExecQuery2("SELECT * FROM dt_Country WHERE name LIKE ? ORDER BY name ASC",Array As String("%" & SearchText & "%"))
"ORDER BY name ASC" it can used only English, If I need to test my language(Thai) ,How to code?