Jeff,
SET EXACT doesn't influence SQL commands. Use SET ANSI instead.
SET ANSI OFF
SELECT * FROM < MyTable > WHERE < MyField > = "T"
or
SELECT * FROM < MyTable > WHERE < MyField > LIKE "T%"
HTH
>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?
Daniel