Caché MultiValue Basic Reference
LOWER
[Back] [Next]
   
Server:docs1
Instance:LATEST
User:UnknownUser
 
-
Go to:
Search:    

Lowers dynamic array delimiters to next level.
Synopsis
LOWER(dynarray)
Arguments
dynarray An expression that resolves to a dynamic array.
Description
The LOWER function returns a dynamic array with its delimiters converted to the next lower-level delimiters. For example, @VM value mark delimiters become @SM subvalue mark delimiters. When a delimiter cannot be lowered any further, it is returned unchanged. A dynarray value that does not contain dynamic array delimiters is returned unchanged.
The available levels, in descending order, are: @IM (CHAR(255)); @FM (CHAR(254)); @VM (CHAR(253)); @SM (CHAR(252)); @TM (CHAR(251)); and CHAR(250).
The RAISE function performs the opposite operation, raising the level of dynamic array delimiters to the next higher level.
Examples
The following example uses the LOWER function to convert dynamic array delimiters to the next lower level. It then uses the RAISE function to reverse this operation:
numvm=123:@VM:456:@VM:789:@VM:"10":@VM:"11"
PRINT numvm;         ! Returns 123ý456ý10ý11
numlower = LOWER(numvm)
PRINT numlower;      ! Returns 123ü456ü10ü11
numraise = RAISE(numlower)
PRINT numraise;      ! Returns 123ý456ý10ý11
See Also