Caché SQL Reference
LEFT
|
|
{fn LEFT(string-expression ,count )}
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). | |
An
integer that specifies the number of characters to return from the starting position
of |
&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" }
Copyright © 1997-2019 InterSystems Corporation, Cambridge, MA
|
Content for this page loaded from RSQL_left.xml on 2019-02-21 02:24:21
|