replace command in oracle sql

[jjenright]

How do I convert the following Crystal 10 code to an SQL statement to be used in a view ?

replace(replace(replace(replace({VIEW_SPECIAL_MAIN.VEN_ITEM},"X","",1),"-",""),".","")," ","")

Thank You, John Enright

 

[synapsevampire]

Do you mean that you intend to use a replace function within a View you are contructing on the database?

Posting the version of Oracle would be helpful, and since you are creating a View, this has nothing to do with Crystal, post in an Oracle forum on tek-tips for the best results, they have some amazing database programmers over there.

Oracle supports basically the same REPLACE syntax:

http://www.techonthenet.com/oracle/functions/replace.php

Note that you use single quotes, not double.

-k