Tag: Conversion
Oracle Datatype Conversions
by Ross (Admin) on Apr.15, 2009, under Oracle, Work
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
Protected: Concatenate Two Fields And Get A Smaller Answer !?!?
by Ross (Admin) on Jun.04, 2008, under MIG, Maxima, Maxima Information Group, Microsoft, SQLServer, Work
Recent Photos
Google Reader- September 5, 2010
- Green Tomato Recipe Call Out
- Workload Management for Operational Data Warehousing
- How To Master GIMP, For Graphics, Quickly And Easily
- The crap we put up with getting on and off an airplane
- Productive Magazine #5 available! Miguel Guía interview about art, passion, habits and more!
- Five top fives in Business Intelligence
- Tomorrow’s must-have IT skills revealed
- Comic for September 1, 2010
- Floating in Space: The Minimalist's Desk [Featured Workspace]
