SQL Select Replace in outsystems

SQL Select Replace in outsystems

  
Hi Dear developers.

I want to do a SELECT replace in outsystems to strip some characters away from the results.

SELECT  REPLACE({Label}.[name],'.lbl',' ')
FROM    {Label}
WHERE   1=1
AND     {Label}.[LabelGroup2Id] = @group_id

but it doesnt worked, is there a any method to do this ? ? ? ? ? ? ? ? ? ?


What is the result you are getting?

At a first glance, that function should be working on SQL Server as well as Oracle. Which one are you using?
Tim Timperman wrote:
What is the result you are getting?

At a first glance, that function should be working on SQL Server as well as Oracle. Which one are you using?
 :) i have resolved it now , in stead of using replace function in sql, i have looped the query with foreach, en stripped with the replace() function of outsystems each record label name, en put it on a other list with the funtion listappend.

And it works now
 
That's another way to do it off course. But depending on the amount of data, it will probably come at a performance cost compared to the sql solution.