What is sql? Why isn't it B4XTable.sql1.... ?
In post#3 I am not using B4XTable.sql because the table is not the in memory database table 'data'. But, when I use the CreateDatView of B4XTable it uses the in memory data table. Therefore this displays what I want, which is uppercase,:
rs=sql.ExecQuery2("SELECT mycol FROM myView WHERE mycol LIKE ?", Array As String ("%J%")) 'displays only uppercase as it should
But this one shows upper and lowercase:
B4XTable1.CreateDataView($"c1 LIKE '%J%' "$)
If it is a limitation of B4XTable CreateDataView, I can work around it by using the SQLite CREATE VIEW, populate a list from the view and repopulate the B4XTable with only uppercase and circumvent B4XTable CreateDataView.