Conditional Statement

[victor.ramalho]

I have one table and any columns. One column is varchar2(50) and your value can be null or letters. My problem is, when I use SELECT Statement this column with LIKE '%', values equal NULL no apeears.

I can't do use this column is my WHERE clause.

Somebody know I resolve this problem ?

Victor Ramalho Peres

[sendilbabu]

Hi
sample code to resolve your problem.


select * from emp
where nvl(ename,' ') like '%'

above query will retreive both ename with null values and values.


Thanks

[victor.ramalho]

This is work corretly.
Thanks of you help.

[agoodman]

What about this?

select * from emp;

(fewer characters, anyhow)