What about the null convert functions in DBMaster(DBMR2355)?
Following are NULL convert function in DBMaster, please reference.
1. IFNULL is an ODBC function. IFNULL (v1, v2) is the equivalent to coalesce(v1,v2) and it’s equivalent to “if v1 is not null, then v1 else v2”.
2. NULLIF is an SQL 99 function. NULLIF(v1, v2) is the equivalent to “if v1=v2 then NULL else v1.
3. COALESCE is an SQL 99 function. COALESCE (v1, v2, v3,….vn) is equivalent to “if v1 IS NOT NULL then v1 else if v2 IS NOT NULL then v3 else………….else vn”.
Version: DBMaker4.x/5.x
Product: Normal /Bundle
Platform: All