Difference between revisions of "LEFT()"

From Recital Documentation Wiki
Jump to: navigation, search
 
(3 intermediate revisions by 2 users not shown)
Line 1: Line 1:
==Class==
 
String Data
 
 
 
 
==Purpose==
 
==Purpose==
 
Function to extract substring from left
 
Function to extract substring from left
Line 8: Line 4:
  
 
==Syntax==
 
==Syntax==
LEFT(<expC>, <expN>)
+
LEFT(<expC> | <memofield>, <expN>)
  
  
 
==See Also==
 
==See Also==
[[AT()]], [[ATNEXT()]], [[INLIST()]], [[OCCURS()]], [[RAT()]], [[RIGHT()]], [[STR()]], [[STREXTRACT()]], [[STRTRAN()]], [[STUFF()]], [[SUBSTR()]]
+
[[AT()]], [[ATNEXT()]], [[INLIST()]], [[OCCURS()]], [[RAT()]], [[RIGHT()]], [[SET STRESCAPE]], [[STR()]], [[STREXTRACT()]], [[STRTRAN()]], [[STUFF()]], [[SUBSTR()]]
  
  
 
==Description==
 
==Description==
The LEFT() function extracts a substring from the left of the character expression <expC> of width <expN> characters wide.  The LEFT() function can be used on character fields in index expressions to extract part of the field in the index key.
+
The LEFT() function extracts a substring from the left of the character expression <expC> or memo <memofield> of width <expN> characters wide.  The LEFT() function can be used on character fields in index expressions to extract part of the field in the index key.
  
  
Line 27: Line 23:
  
 
==Products==
 
==Products==
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
+
Recital Server, Recital  
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Functions]]
 
[[Category:Functions]]
 
[[Category:String Data]]
 
[[Category:String Data]]
 
[[Category:String Data Functions]]
 
[[Category:String Data Functions]]

Latest revision as of 13:26, 21 July 2010

Purpose

Function to extract substring from left


Syntax

LEFT(<expC> | <memofield>, <expN>)


See Also

AT(), ATNEXT(), INLIST(), OCCURS(), RAT(), RIGHT(), SET STRESCAPE, STR(), STREXTRACT(), STRTRAN(), STUFF(), SUBSTR()


Description

The LEFT() function extracts a substring from the left of the character expression <expC> or memo <memofield> of width <expN> characters wide. The LEFT() function can be used on character fields in index expressions to extract part of the field in the index key.


Example

? left("Christopher",5)
Chris


Products

Recital Server, Recital