Subject Finding the closest match
Author Carl Boshoff
Hey ppl

I do a normal SELECT like this:
SELECT * FROM milliontest WHERE testid like 'A%' ORDER BY testid
And it returns (for example) 100 records, because I have records starting
with 'A' in the database.

Now if I do the same select, but using 'B%', in that select it does not
return anything, since there are no records starting with 'B'. The nearest
match is a record starting with 'D'.

How can I get the select statement to return the closest match after B?

Carl Boshoff