Is it possible to get access to the search field (The value that I am typing in)? I would like to sort the results in a search application like this:
ORDER BY INSTR(field1,searchfield), field1
searchfield is what I am actually typing in the search field not the field that I am searching in. I am using the data type Text Auto-Complete so that I can enter my own SQL statement.