NVL , isNuLL equivalent in DB2

vinbie · #1 (**permalink**) 10-29-03, 09:57

I have SQL like

select columnname from table t order by NVL(columnname, ' ') ASC

Above query for oracle fetches the null 'columnname' first. Similarly we use isNull() function for SQL Server.

Please let me know the equivalent function in DB2.

NULLIF does not serve my purpose

sathyaram_s · #2 (**permalink**) 10-29-03, 10:02

coalesce

This has been discussed earlier .. A search for NVL would have given you the answer

Sathyaram

Quote:

Originally posted by vinbie
I have SQL like

select columnname from table t order by NVL(columnname, ' ') ASC

Above query for oracle fetches the null 'columnname' first. Similarly we use isNull() function for SQL Server.

Please let me know the equivalent function in DB2.

NULLIF does not serve my purpose

Internet Services

Web Development

Digital Marketing

Consumer Tech