Regarding: If you can't upgrade you simply need to calculate the length
as well.
... then substr(artist, 5, length(artist)-4)
Am I right that it's ok to simply specify a large value for the third
parameter?
SQLite version 3.3.12
select substr('The Quick Brown Fox', 5, 999);
Quick Brown Fox
It's possible that you'll still end up wanting to add a "sort_by" column
if it matters that, e.g., a group named "The E-mails" is sorted the same
as "The Emails".
"How do I sort 'the, '? Let me count the ways."
This email and any attachments have been scanned for known viruses using
multiple scanners. We believe that this email and any attachments are virus
free, however the recipient must take full responsibility for virus checking.
This email message is intended for the named recipient only. It may be
privileged and/or confidential. If you are not the named recipient of this
email please notify us immediately and do not copy it or use it for any
purpose, nor disclose its contents to any other person.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
