Thanks

That works, it helps having fresh eyes on a problem sometimes, it looks so
simple now.

Lol


-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Adomas Urbanavicius
Sent: 21 November 2005 12:00
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Finding the closest match

select first 100 from tableX where name >= 'B'
order by name asc
Just not sure if there has be 'B' or 'B ' :)
Adomas
Carl Boshoff wrote:

>Hey ppl
>
>
>I do a normal SELECT like this:
> SELECT * FROM milliontest WHERE testid like 'A%' ORDER BY testid

ASC;

>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?
>
>
>Thanks
>Carl Boshoff
>
>
>
>
>
>
>
>
>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>Visit http://firebird.sourceforge.net and click the Resources item on
>the main (top) menu. Try Knowledgebase and FAQ links !
>
>Also search the knowledgebases at http://www.ibphoenix.com
>
>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>
>

------------------------ Yahoo! Groups Sponsor --------------------~--> Get
fast access to your favorite Yahoo! Groups. Make Yahoo! your home page
http://us.click.yahoo.com/dpRU5A/wUILAA/yQLSAA/67folB/TM
--------------------------------------------------------------------~->

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://firebird.sourceforge.net and click the Resources item on the
main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Yahoo! Groups Links