Oct
Returns a string representing the octal value of a number.
Syntax
Oct(Val)
Parameter
Val
Type: Long
Numeric value.
(return)
Type: Text
Octal representation of Val.
Remarks
Val is treated as an unsigned number, so values of -2147483648 to -1 are represented as "20000000000" to "37777777777" respectively. If the current data value is NULL, Val is 0 and the return value is "0".
This function is similar to the Oct function in Visual Basic.
Example
This example uses the Oct function to return the octal value of 99:
Dim x, y
x = 99
y = Oct(x)
The return value is “143”.
See also