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
Apr 152009
Whilst nowhere near as ambitious as J.D. and Kris’ project here I have decided to do some work in the garden this year. I’m a few weeks behind writing up my progress so I’ll try and summarise after the break.
Apr 072009
Follow me on Twitter 
Recent Comments