Thank you for responding Simon,
Please see my last response to this thread where I copied more data from the
console.
I have to obfuscate the data somewhat unfortunately before public posting? but
I preserved all structure and types as in original data.
Thanks,
--
adam
> On 19 May 2015, at 20:26, Simon Slavin <slavins at bigfraud.org> wrote:
>
>
> On 19 May 2015, at 6:39pm, Adam Podstawczy?ski <adam at podstawczynski.com>
> wrote:
>
>> Now, the above query is expected to return one record only
>
> Please check your post. The line you say is returned is not in the data you
> included in your post.
>
> Here's your data in a readable form to work with:
>
> CREATE TABLE list_of_numbers (
> nn TEXT,
> astart INT,
> aend INT,
> alength INT,
> usesflag TEXT,
> blength INT,
> coolflag NUM,
> alphaid
> );
> INSERT INTO list_of_numbers VALUES
> ('1','7017000000','7017009999','9','Y','10','0','1b9633407507819ni');
> INSERT INTO list_of_numbers VALUES
> ('1','7017070000','7017039999','9','Y','10','0','1b6033960773078ni');
> INSERT INTO list_of_numbers VALUES
> ('1','7017040000','7017059999','9','Y','10','0','1b9633407507819ni');
> INSERT INTO list_of_numbers VALUES
> ('1','7017060000','7017069999','9','Y','10','0','1b6033960773078ni');
> INSERT INTO list_of_numbers VALUES
> ('1','7017070000','7017079999','9','Y','10','0','1b6033939751871ni');
> INSERT INTO list_of_numbers VALUES
> ('1','7017080000','7017099999','9','Y','10','0','1b9633407507819ni');
>
> select * from list_of_numbers where astart < 7169319380 and aend > 7169319380;
>
> Simon.
> _______________________________________________
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
