InterSystems IRIS Data Platform 2019.2  /  InterSystems SQL Reference

InterSystems SQL Reference
Previous section           Next section
InterSystems: The power behind what matters   

A scalar string function that returns a specified number of characters from the beginning (leftmost position) of a string expression.
{fn LEFT(string-expression,count)}
string-expression A string expression, which can be the name of a column, a string literal, or the result of another scalar function, where the underlying data type can be represented as any character type (such as CHAR or VARCHAR).
count An integer that specifies the number of characters to return from the starting position of string-expression.
LEFT returns the specified number of characters from thebeginning of a string. LEFT does not pad strings; if you specifya larger number of characters than are in the string, LEFT returnsthe string. LEFT returns NULL if passed a NULL value for eitherargument.
LEFT can only be used as an ODBC scalar function (withthe curly brace syntax).
The following example returns the seven leftmost characters from each name in the Sample.Person table:
SELECT Name,{fn LEFT(Name,7)}AS ShortName
     FROM Sample.Person
The following embedded SQL example shows how LEFT handlesa count that is longer than the string itself:
   &sql(SELECT Name,{fn LEFT(Name,40)}
   INTO :a,:b
   FROM Sample.Person)
   IF SQLCODE'=0 {
     WRITE !,"Error code ",SQLCODE }
   ELSE {
     WRITE !,a,"=original",!,b,"=LEFT 40" }
No padding is performed.
See Also

Previous section           Next section
Send us comments on this page
View this book as PDF   |  Download all PDFs
Copyright © 1997-2019 InterSystems Corporation, Cambridge, MA
Content Date/Time: 2019-08-22 06:48:58