STARTS-WITH and ENDS-WITH searches are the bread-and-butter of text-centric/word-centric applications (e.g. in linguistics and philology) where you have to work with suffixes, prefixes, and enclitic|proclitic particles quite often. You must routinely examine the ends of strings in a wide range of other applications too. If you've ever had to import "data" such as a mailing list that a "power-user" has created in a spreadsheet, using a row for each address line but only one column, most likely you've have occasion to flip a thing or two.
You can accomplish this on the front-end, of course, but it would be much more convenient and efficient to have a built-in function. Given the range of possible uses for it, this flip(string) function would be far more versatile than a REVERSED collation sequence. Thanks for considering. P.S. I have no experience programming in C, so it's not the kind of thing I'd undertake on my own. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
