Skip to content
Related Articles

Related Articles

Improve Article
Hex() and Oct() Function Function in MS Access
  • Last Updated : 14 Sep, 2020

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 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 :

HexNumber
2

Example-2 : Hexadecimal representation of 13.

SELECT Hex(13) AS HexNumber;

Output :

HexNumber
D

Example-3 : Hexadecimal representation of 1134.80.

SELECT Hex(1134.80) AS HexNumber;        

Output :

HexNumber
46F

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 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 :

OctNumber
7

Example-2 : Octal representation of 111.45.

SELECT Oct(111.45) AS OctNumber;                

Output :

OctNumber
157
My Personal Notes arrow_drop_up
Recommended Articles
Page :