x <tam118...@hotmail.com> wrote: > Don’t think you’ll get it any less ugly than > > substr('SunMonTueWedThuFriSat',strftime('%w',Date)*3+1,3); > Yes, thanks, that's where I had got to! :-)
-- Chris Green · _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users