Difference between revisions of "STRLEN()"

From Lianjapedia
Jump to: navigation, search
(See Also)
Line 6: Line 6:
  
 
==See Also==
 
==See Also==
[[AT()]], [[LEFT()]], [[LEN()]], [[LENC()]], [[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==

Revision as of 12:45, 22 March 2021

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

Products

Lianja Server, Lianja