SQL Select text replace 1

[deulyd]

Hi,

I'd like to know if there is a way to do that in an SQL query :

I have a table with the following fields and data

ID TYPE
------- ----------
1 CALL
2 CALL
3 INTERNAL
4 EMAIL
5 CALL

I'd like to have an SQL statement that would return me the following by replacing :

CALL by 'E'
EMAIL by 'E'
INTERNAL' by 'I'

ID TYPE
------- ----------
1 E
2 E
3 I
4 E
5 E


Thanks

Daniel

 

[kskid]

Try this.

Decode(type,'INTERNAL','I','E') type

 

[deulyd]

Thanks, It's exactly what I was looking for!

Daniel