Cécilia Vigny wrote:
Hi,
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.
http://www.sqlite.org/lang_expr.html
substr(X,Y,Z):
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
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
http://pse.2cah.com
Controlling pseudoephedrine purchases.
http://www.mtsprofessional.com/
A Win32 email server that works for You.
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
