Complicated database problem

There are two columns in a database table. These two columns are of
type TEXT. They store the FROM and TO values for a certain range. These
values are exceptionally large and cannot be stored as numeric values.
Each range is mutually exclusive and does not overlap. You are free to
add more columns as needed to aid in the solution. I need to write the
following query: Given a String (i.e. a large number) as input, select
the range in which it lies.

Example: This example uses small numbers for clarity.
FROM | TO
----------+---------
100 | 999
1000 | 1999
2000 | 3999

Input: 400

Output:
FROM | TO
---------+-----
100 | 999

Please help me solve this problem.
Thanks in advance.

Best regards.

.

Relevant Pages

  • Re: public and private mailboxes randomly dismounting
    ... When posting logs an important piece is the Event ID and Source. ... Information Store First Storage Group: An attempt to move the file ... An error occurred while writing to the database log file of storage group ...
    (microsoft.public.windows.server.sbs)
  • Re: cant mount information store
    ... I then reinstalled exchange and then installed exchange 2003 ... Information Store First Storage Group: Database recovery failed ... Microsoft Exchange Information Store. ...
    (microsoft.public.windows.server.sbs)
  • Re: Many Exchange errors!
    ... Event Source: ESE ... Information Store First Storage Group: An attempt to move the file ... An error occurred while writing to the database log file of storage group ...
    (microsoft.public.windows.server.sbs)
  • Re: Many Exchange errors!
    ... Event Source: ESE ... Information Store First Storage Group: An attempt to move the file ... An error occurred while writing to the database log file of storage group ...
    (microsoft.public.windows.server.sbs)
  • Re: Many Exchange errors!
    ... Event Source: ESE ... Information Store First Storage Group: ... An error occurred while writing to the database log file of storage ...
    (microsoft.public.windows.server.sbs)