I am calling a bind variable in SQLITE using the following:
select * from info where fg_ring = ?
But I would like to get the results of the following:
select * from info where fg_ring like '%upper(?)%'
Unfortunately, I can't get it to work - error I am getting is:
03-25 12:23:53.309: ERROR/AndroidRuntime(2769)
: Caused by: android.database.sqlite.SQ
ion: bind or column index out of range: handle 0x2e13c8
Even if I remove the upper() function, it's still not working. Anyone have any hints on how to get this? Or is it set in stone that bind can only work with "=" operator?