AppLib LEFTN

From Eigenpedia

(Redirected from LucidDbAppLib LEFTN)
Jump to: navigation, search

Contents

Syntax 

APPLIB.LEFTN ( string, number )

Purpose

Returns the leftmost 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.

Output

  • [VARCHAR(65535)] - string of leftmost characters

Example

NAME LEFTN( NAME, 2 )
345 34
Bernard Walsh Be
Joan Yu Jo
Martin Blair Ma
Mike Rodriguez Mi
Olivia Kuznetsov Ol
walter king wa

Source Code

http://p4web.eigenbase.org/open/dev/luciddb/src/com/lucidera/luciddb/applib/string/LeftNUdf.java

Retrieved from "http://pub.eigenbase.org/wiki/AppLib_LEFTN"
Personal tools