Caché MultiValue Basic Reference
LOWER

 Server:docs1 Instance:LATEST User:UnknownUser

 [ Home ]  >  [ MultiValue Features of Caché ]  >  [ Caché MultiValue Basic Reference ]  >  [ Caché MultiValue Basic Functions ]  >  [ LOWER ] Go to: Description Examples See Also 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```