[RBASE-L] - Re: removing numbers from a string

[Lawrence Lustig]

> IE if i have a string like "34hello65748world" stored in a column I'm trying
> to get "helloworld".
> 
> is there a way to do that in a select statement?

You can do it with

SELECT (SRPL(SRPL(SRPL(ColName, '0', '', 0), '1', '', 0), '2', '', 0)) +
  FROM TableName

(the example only does 1..3, you need to make it longer and even uglier to get
all 10 digits) or with:

SELECT (CALL StripNumbers(ColName)) FROM TableName

if you write a stored procedure to do what you want (which can be done in
several different ways) or

SELECT (UDF('@FunctionName', ColName)) FROM TableName

if you write a UDF to do it.
--
Larry