STR UNCOMPRESS()

From Lianjapedia
Jump to: navigation, search

Purpose

Function to uncompress a character string

Syntax

STR_UNCOMPRESS(<expC>)

See Also

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

Description

The STR_UNCOMPRESS() function returns the compressed character string in character expression <expC> as an uncompressed character string.

The corresponding STR_COMPRESS() function can be used to compress a character string or varchar/memo field.

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)