Hi Jose,
you are probably looking for the between-Operator: Open
http://www.sqlite.org/lang_expr.html and search for "The BETWEEN operator"
inn you case, date BETWEEN '2014-01-01' AND '2014-01-05'
Martin
Am 14.09.2014 07:07, schrieb jose isaias cabrera:
Greetings!
I know that the IN clause contains a list of something. I.e.
IN ('2014-01-01', '2014-01-02', '2014-01-03', '2014-01-04', '2014-01-05')
So the question is, is there a shorter way for one to say something like,
IN ('2014-01-01', ..., '2014-01-05')
where the content of the IN would have the first item and the last
item of the list, but that's it? Thanks.
josé
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
--
*Codeswift GmbH *
Kräutlerweg 20a
A-5020 Salzburg
Tel: +49 (0) 8662 / 494330
Mob: +49 (0) 171 / 4487687
Fax: +49 (0) 3212 / 1001404
engelsch...@codeswift.com
www.codeswift.com / www.swiftcash.at
Codeswift Professional IT Services GmbH
Firmenbuch-Nr. FN 202820s
UID-Nr. ATU 50576309
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
