Specifications

MidA
710 InfoMaker
To pass this validation rule, the fourth character in the column password must
be 6:
Mid(password, 4, 1) = "6"
MidA
Description Obtains a specified number of bytes from a specified position in a string.
Syntax MidA ( string, start {, length } )
Return value
String. Returns characters specified by the number of bytes in length of string
starting at the byte specified by start. If start is greater than the number of bytes
in string, the
MidA function returns the empty string (“”). If length is greater
than the number of bytes remaining after the start byte,
MidA returns the
remaining bytes. The return string is not filled with spaces to make it the
specified length.
Usage MidA replaces the functionality that Mid had in DBCS environments in
InfoMaker 9. In SBCS environments,
Mid and MidA return the same results.
See also Mid
Min
Description Gets the minimum value in the specified column.
Syntax Min ( column { FOR range { DISTINCT { expres1 {, expres2 {, ... } } } } } )
Argument Description
string The string from which you want characters returned.
start A long specifying the position of the first byte you want returned
(the position of the first byte of the string is 1).
length
(optional)
A long whose value is the number of bytes you want returned. If
you do not enter length or if length is greater than the number of
bytes to the right of start,
MidA returns the remaining bytes in the
string.