Advanced Search

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