Oralce syntax

July 31st, 2009 | mylinh | 0 Comments »

Question:
Can you explain to me what the belwo query is tryingot do ? is it trying ot grab only the numeric value?
where LENGTH(TRIM(TRANSLATE(tr.result_value, ‘ +-.0123456789′, ‘ ‘))) is null
Solution:
the really correct syntax should be
where LENGTH(TRIM(TRANSLATE(tr.result_value, ‘ +-.0123456789′, ‘ ‘))) = 0
and it would test, if there is no other symbol in the field result_value than [...]