Dennis Cote wrote: > Andrew Gatt wrote: > >> Error: wrong number of arguments to function substr() >> >> I'm using sqlite 3.3.6, but i'm presuming the two and three variable >> substr functions go back further than this? Doing tests it seems to be >> the two variable version it doesn't like. Do i need to upgrade my sqlite >> library? >> >> > > Yes, this feature was added in version 3.5.2 (see > http://www.sqlite.org/changes.html) so you will need to upgrade to use > this form of the function. > > If you can't upgrade you simply need to calculate the length as well. > > select * from t > order by > case > when lower(substr(artist, 1, 4)) = 'the,' > then substr(artist, 5, length(artist)-4) > when lower(substr(artist, 1, 3)) = 'the' > then substr(artist, 4, length(artist)-3) > else artist > end; > > HTH > Dennis Cote > > That's got it (i'll upgrade at some point and revert to the previous example). I've also changed 'the' to 'the ' as mentioned in another email.
Thanks for everyone's help. Andrew _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
