will substr + not function ignore null values ?
620942Jun 17 2008 — edited Jun 18 2008hi guys
i have a table test with 1 column named (value) of varchar2 type.
inside this table, i have 3 rows.
1) 2255
2) null
3) 5522
when i do select * from test where substr(value,1,1) not in ('3'), it only returns me
row 1) 2255
row 3) 5522
but why doesnt it return me row 2 with null value as well ?
since substr(null) will generate null. and null is also NOT IN ('3'), why doesnt it shows?
any ideas guys ?