Difference between revisions of "LEN()"
From Lianjapedia
Yvonne.milne (Talk | contribs) |
Yvonne.milne (Talk | contribs) (→See Also) |
||
Line 6: | Line 6: | ||
==See Also== | ==See Also== | ||
− | [[AT()]], [[LEFT()]], [[LENC()]], [[RAT()]], [[RIGHT()]], [[SET STRESCAPE]], [[STREXTRACT()]], [[STRLEN()]], [[STRTRAN()]], [[STUFF()]], [[SUBSTR()]] | + | [[AT()]], [[LEFT()]], [[LENC()]], [[RAT()]], [[RIGHT()]], [[SET STRESCAPE]], [[STR_COMPRESS()]], [[STR_UNCOMPRESS()]], [[STREXTRACT()]], [[STRLEN()]], [[STRTRAN()]], [[STUFF()]], [[SUBSTR()]] |
==Description== | ==Description== |
Latest revision as of 12:45, 22 March 2021
Contents
Purpose
Function to return length of specified expression
Syntax
LEN(<exp>[,<expL>])
See Also
AT(), LEFT(), LENC(), RAT(), RIGHT(), SET STRESCAPE, STR_COMPRESS(), STR_UNCOMPRESS(), 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. The optional <expL> is ignored.
Use the LENC() function when working with Unicode/UTF-8 characters.
Example
open database southwind use example ? len(last_name) 16 ? len(notes) 8851 ? len("") 0