problems with replace

[mokesql]

hey guys!
i want to use the replace funktion to replace something out of a string. in fact its the problem that i want to replace the substring '/SMS' by nothing. so i tryed replace(variable, '/SMS', '') and after that i tryed also replace(variable, '/SMS') but neighter worked. what could be the problem? thanx for the help

kemo

 

[rcurva]

How about;

SELECT REPLACE('SAMPLE/SMS ONLY','/SMS',NULL)
FROM SYS.DUAL;

 

[sem]

You may ommit the third parameter as it's null by default.
Your problem is possibly not in sql syntax but rather in using / as a special character in your calling environment (PRO*C?). Normally you have to use // or quote it in some way to cancel its special meaning.