STR COMPRESS()

Purpose

Function to compress a character string or memo field

Syntax

STR_COMPRESS(<expC> | <memofield>)

See Also

AT(), ATNEXT(), CHRTRAN(), INLIST(), LEFT(), OCCURS(), RAT(), RIGHT(), SET STRESCAPE, STR(), STR_REPLACE(), STR_UNCOMPRESS(), STREXTRACT(), STRTRAN(), STUFF(), SUBSTR()

Description

The STR_COMPRESS() function returns the character expression <expC> or varchar/memo <memofield> as a compressed character string.

The corresponding STR_UNCOMPRESS() function can be used to uncompress the character string.

Example

open database southwind
use example
goto 40
cExpr1 = mtos(notes)
cComp1 = str_compress(cExpr1)
cUncomp1 = str_uncompress(cComp1)
cComp2 = str_compress(notes)
cUncomp2 = str_uncompress(cComp2)