Last week I gave a colleague a demonstration on why, if you have numbers stored in a character string you should convert them explicitly to numbers:
select ‘Yes’
from dual
where ‘1000’ between ‘000’ and ‘999’;‘YES’
—–
Yes
Last week I gave a colleague a demonstration on why, if you have numbers stored in a character string you should convert them explicitly to numbers:
select ‘Yes’
from dual
where ‘1000’ between ‘000’ and ‘999’;‘YES’
—–
Yes