/ Published in: SQL
Expand |
Embed | Plain Text
Copy this code and paste it in your HTML
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