>I have a select statement that needs to search for the nearest matches in a talbe. If the user enters "T" in the search field, then the select statment to select all those records that begin with T. Set near is ON, Set Exact is Off. But what happens is that all the records that begin with T show up but so does everything after T, names with U, V,W, X, Y,Z....can anyone assist?
The correct way to do this with SQL is:
cValue = upper(alltrim(ThisForm.txtUserInput.Value)) + "%"
select ... from ... where upper(SomeField) like ?cValue
To make sure it is Rushmore optimized, SomeField needs an index tag on upper(SomeField)
Mark McCasland
Midlothian, TX USA