Problem using SQL case statement - oracle

**Oracleguy** · 12-10-2012, 07:20 AM

I am new to oracle sql. The data in one of the columns is

Code:

1.2.10.00.12

When i find "0.00.", i want to replace it with hyphen(-). The output should be

Code:

1.2.1-12

I tried the following case statement:

Code:

case column when '0.00.' then - else column end alias_name

I am not getting the required output. Please help me in this.

**yoursswathi** · 12-10-2012, 10:35 AM

Use a replace function instead of the case statement.

Code:

select replace('1.2.10.00.12','0.00.','-') from dual

Thread: Problem using SQL case statement - oracle