Re: Selecting only numbers from a string or vice versa

Aki Karjalainen wrote: Hi. I've got a problem where I need to drop everything but numbers from a string and evaluate against it. E.g. SELECT * FROM MYDATA WHERE DROP_ALL_LETTERS(MYSTRING) = '1254' or SELECT * FROM MYDATA WHERE REMOVESUBSTRINGS('A-Z', MYSTRING) = '1254' 10 points to the one whos k

Selecting only numbers from a string or vice versa

Hi. I've got a problem where I need to drop everything but numbers from a string and evaluate against it. E.g. SELECT * FROM MYDATA WHERE DROP_ALL_LETTERS(MYSTRING) = '1254' or SELECT * FROM MYDATA WHERE REMOVESUBSTRINGS('A-Z', MYSTRING) = '1254' 10 points to the one whos knows how to do a qu