Cécilia Vigny wrote:

Does SQLite supports the right(string, len) function ?

For instance :

SELECT myfield, right(myfield,5) FROM mytable
where myfield = "aaaaaaaaaaaaaaaaaaaaaaaaaaa";

I've got an error near '(' when executing this request.



Return a substring of input string X that begins with the Y-th character and which is Z characters long. The left-most character of X is number 1. If Y is negative the the first character of the substring is found by counting from the right rather than the left. If SQLite is configured to support UTF-8, then characters indices refer to actual UTF-8 characters, not bytes.

Craig Morrison
  Controlling pseudoephedrine purchases.

  A Win32 email server that works for You.

To unsubscribe, send email to [EMAIL PROTECTED]

Reply via email to