Checking first two digits of a number

[Stretchwickster]

Hi,

I want to be able to affirm that the first two digits of an 8-digit number are equal to 01. I'm familiar with achieving this when manipulating strings but not with numbers - could I use some kind of integer division function that returns just the integer part of the result e.g. in another programming language I would do

anumber div 100

and it returns the integer part of the result

Clive

 

[stefanhei]

Hi.
Convert the number to character and then check:

to_char(anumber,'fm00000000')

or if you need the most right digits:

mod(anumber,100)

Stefan