What about the null convert functions in DBMaster(DBMR2355)?

~ 0 min
2016-03-18 03:06

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

Average rating 0 (0 Votes)

You cannot comment on this entry

Tags