Re: [sqlite] Right() function

[Craig Morrison]

Cécilia Vigny wrote:

Hi,

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

For instance :

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

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]
-

[sqlite] Right() function

[Cécilia Vigny]

Hi,

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

For instance :

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

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

Thanks.


Ce message est prot?g? par les r?gles relatives au secret des correspondances. 
Il est donc ?tabli ? destination exclusive de son destinataire. Celui-ci peut 
donc contenir des informations confidentielles. La divulgation de ces 
informations est ? ce titre rigoureusement interdite. Si vous avez re?u ce 
message par erreur, merci de le renvoyer ? l'exp?diteur dont l'adresse e-mail 
figure ci-dessus et de d?truire le message ainsi que toute pi?ce jointe.

This message is protected by the secrecy of correspondence rules. Therefore, 
this message is intended solely for the attention of the addressee. This 
message may contain privileged or confidential information, as such the 
disclosure of these informations is strictly forbidden. If, by mistake, you 
have received this message, please return this message to the addressser whose 
e-mail address is written above and destroy this message and all files attached.



-
To unsubscribe, send email to [EMAIL PROTECTED]
-