>>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?
>
>Try SET KEY TO 'T' RANGE 'Tz'
>
>Never tried this on SELECT, but I think it works there too.
>It scopes to a "filter" on the given range, and uses the concerning index (yep, which you must have).

you could not worry about the set exact and
select * from TableName where Lname = "T%"

Notice the single equels sign.
you could replace the Lname = "T%" with between(Lname, "T%", "Sn") for a specific range.

or a little bit of a messy solution for a range where the Starting or ending value may produce 0 hits ( cut and paste from working program ):

select *, recno() as recno from part where id like m.ending ;
union ;
select *, recno() as recno from part where id like m.Starting ;
union ;
select *, recno() as recno from part where between(id, m.Starting, m.Ending ) ;
into cursor realtemp ;
order by 1
- jer