Skip to Content (Press Enter)
2012-10-24 09-55-24
Kadir Karapinar
43Views
3Comments
SQL Select Replace in outsystems
Question
SQL
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 ? ? ? ? ? ? ? ? ? ?


0
0
23 Oct 2013
Copy Link
2020-04-17 08-41-30
Tim Timperman
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?
1
0
23 Oct 2013
Copy Link
2012-10-24 09-55-24
Kadir Karapinar
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
 
0
0
23 Oct 2013
Copy Link
2020-04-17 08-41-30
Tim Timperman
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.
0
0
23 Oct 2013
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.