Difference between revisions of "STRLEN()"
From Lianjapedia
Yvonne.milne (Talk | contribs) (→Products) |
|||
| (5 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
Function to return length of specified expression | Function to return length of specified expression | ||
| − | |||
==Syntax== | ==Syntax== | ||
STRLEN(<exp>[,<expL>]) | STRLEN(<exp>[,<expL>]) | ||
| − | |||
==See Also== | ==See Also== | ||
| − | [[AT()]], [[LEFT()]], [[LEN()]], [[RAT()]], [[RIGHT()]], [[SET STRESCAPE]], [[STREXTRACT()]], [[STRTRAN()]], [[STUFF()]], [[SUBSTR()]] | + | [[AT()]], [[LEFT()]], [[LEN()]], [[LENC()]], [[RAT()]], [[RIGHT()]], [[SET STRESCAPE]], [[STR_COMPRESS()]], [[STR_UNCOMPRESS()]], [[STREXTRACT()]], [[STRTRAN()]], [[STUFF()]], [[SUBSTR()]] |
| − | + | ||
==Description== | ==Description== | ||
| − | The STRLEN() function returns the output width of the specified expression <exp>. The expression can be of any data type, including memo fields and arrays. | + | The STRLEN() 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 25: | Line 21: | ||
? strlen("") | ? strlen("") | ||
0 | 0 | ||
| − | |||
| − | |||
| − | |||
| − | |||
</code> | </code> | ||
| − | |||
| − | |||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
| + | [[Category:String Data Functions]] | ||
Latest revision as of 12:45, 22 March 2021
Contents
Purpose
Function to return length of specified expression
Syntax
STRLEN(<exp>[,<expL>])
See Also
AT(), LEFT(), LEN(), LENC(), RAT(), RIGHT(), SET STRESCAPE, STR_COMPRESS(), STR_UNCOMPRESS(), STREXTRACT(), STRTRAN(), STUFF(), SUBSTR()
Description
The STRLEN() 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 ? strlen(last_name) 16 ? strlen(notes) 8851 ? strlen("") 0
