Revision: 43850
Initial Code
Initial URL
Initial Description
Initial Title
Initial Tags
Initial Language
at April 1, 2011 04:15 by marvin9000
Initial Code
LENGTH(TRIM(TRANSLATE('123b', ' +-.0123456789',' '))); --would return 1 LENGTH(TRIM(TRANSLATE('a123b', ' +-.0123456789',' '))); --would return 2 LENGTH(TRIM(TRANSLATE('1256.54', ' +-.0123456789',' '))); --would return null LENGTH(TRIM(TRANSLATE ('-56', ' +-.0123456789',' '))); --would return null
Initial URL
Initial Description
Initial Title
Test String is numeric
Initial Tags
Oracle
Initial Language
SQL