Difference between revisions of "LEN()"
From Lianjapedia
Yvonne.milne (Talk | contribs) |
Yvonne.milne (Talk | contribs) |
||
Line 9: | Line 9: | ||
==Description== | ==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 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. |
==Example== | ==Example== | ||
Line 21: | Line 21: | ||
? len("") | ? len("") | ||
0 | 0 | ||
− | |||
− | |||
− | |||
− | |||
</code> | </code> | ||
Revision as of 05:40, 15 September 2014
Contents
Purpose
Function to return length of specified expression
Syntax
LEN(<exp>[,<expL>])
See Also
AT(), LEFT(), LENC(), 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. The optional <expL> is ignored.
Example
open database southwind use example ? len(last_name) 16 ? len(notes) 8851 ? len("") 0