STR UNCOMPRESS()
From Lianjapedia
Revision as of 12:15, 22 March 2021 by Yvonne.milne (Talk | contribs)
Contents
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)