LucidDbAppLib RIGHTN
From Eigenpedia
Contents |
Syntax
APPLIB.RIGHTN ( string, number )
Purpose
Returns the rightmost number of characters of the specified string
Input
- string [VARCHAR(65535)]: the string from which to take the characters
- number [INTEGER]: the number of characters to return from the right end of the string
Output
- [VARCHAR(65535)] - string with rightmost characters, returns null on null input
Example
| NAME | RIGHTN( NAME, 2 ) |
|---|---|
| 345 | 45 |
| Bernard Walsh | sh |
| Joan Yu | Yu |
| Martin Blair | ir |
| Mike Rodriguez | ez |
| Olivia Kuznetsov | ov |
| walter king | ng |
Source Code
http://p4web.eigenbase.org/open/dev/luciddb/src/com/lucidera/luciddb/applib/string/RightNUdf.java
Return to LucidDbAppLib page
