Return to Snippet

Revision: 43850
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