Difference between revisions of "LEN()"

From Recital Documentation Wiki
Jump to: navigation, search
 
(3 intermediate revisions by 2 users not shown)
Line 1: Line 1:
==Class==
 
Expressions and Type Conversion
 
 
 
 
==Purpose==
 
==Purpose==
 
Function to return length of specified expression
 
Function to return length of specified expression
Line 12: Line 8:
  
 
==See Also==
 
==See Also==
[[AT()]], [[LEFT()]], [[RAT()]], [[RIGHT()]], [[STREXTRACT()]], [[STRLEN()]], [[STRTRAN()]], [[STUFF()]], [[SUBSTR()]]
+
[[AT()]], [[LEFT()]], [[RAT()]], [[RIGHT()]], [[SET STRESCAPE]], [[STREXTRACT()]], [[STRLEN()]], [[STRTRAN()]], [[STUFF()]], [[SUBSTR()]]
  
  
Line 23: Line 19:
 
open database southwind
 
open database southwind
 
use example
 
use example
? strlen(last_name)
+
? len(last_name)
 
         16
 
         16
? strlen(notes)
+
? len(notes)
 
       8851
 
       8851
 
? len("")
 
? len("")

Latest revision as of 13:24, 21 July 2010

Purpose

Function to return length of specified expression


Syntax

LEN(<exp>[,<expL>])


See Also

AT(), LEFT(), RAT(), RIGHT(), SET STRESCAPE, STREXTRACT(), STRLEN(), STRTRAN(), STUFF(), SUBSTR()


Description

The LEN() function returns the output width of the specified expression <exp>. The expression can be of any data type, including memo fields and arrays. When checking the length of character expressions, the optional <expL> can be specified. If <expL> is specified and evaluates to .T. (true), the LEN() function will return the length of the character expression after stripping any formatting options such as BOLD().


Example

open database southwind
use example
? len(last_name)
        16
? len(notes)
      8851
? len("")
         0
? len(bold("Hello"))
         9
? len(bold("Hello"),.T.)
         5


Products

Recital Server, Recital