Hex() and Oct() Function Function in MS Access

1. Hex() Function : Hex() Function in MS Access is used to returns a String representing the hexadecimal value of a number. Syntax :

`Hex(number)`

Parameter : This method accepts one parameter as mentioned above and described below :

• number : It is any valid numeric expression or string expression.

Returns : If the number is null it returns null, if the number is Empty then it returns Zero (0). Otherwise it returns a String representing the hexadecimal value of a number. Note : If number is not already a whole number, it is rounded to the nearest whole number before being evaluated. Example-1 : Hexadecimal representation of 2.

`SELECT Hex(2) AS HexNumber;`

Output :

Example-2 : Hexadecimal representation of 13.

`SELECT Hex(13) AS HexNumber;`

Output :

Example-3 : Hexadecimal representation of 1134.80.

`SELECT Hex(1134.80) AS HexNumber;        `

Output :

2. Oct() Function : Oct() Function in MS Access is used to returns a String representing the octal value of a number. Syntax :

`Oct(number)`

Parameter : This method accepts one parameter as mentioned above and described below :

• number : It is any valid numeric expression or string expression.

Returns : If the number is null it returns null, if the number is Empty then it returns Zero (0).Otherwise it returns a String representing the octal value of a number. Note : If number is not already a whole number, it is rounded to the nearest whole number before being evaluated. Example-1 : Octal representation of 7.

`SELECT Oct(7) AS OctNumber;                `

Output :

Example-2 : Octal representation of 111.45.

`SELECT Oct(111.45) AS OctNumber;                `

Output :

Previous
Next