Replace a NULL with specific value - Revision history

Connor: Created page with "Replace a NULL with a specific value

schema:gisq

The SQL standard is COALESCE

2012-07-17T14:53:09Z

Created page with "Replace a NULL with a specific value <div class='ht'> <div class=params>schema:gisq</div> <div> The SQL standard is COALESCE </div> <source lang=sql class='tidy'..."

New page
Replace a NULL with a specific value
<div class='ht'>
<div class=params>schema:gisq</div>
<div>
The SQL standard is [[COALESCE |COALESCE]]
</div>
<source lang=sql class='tidy'>
</source>
<source lang=sql class='setup'></source>
<source lang='sql' class='def e-access'>SELECT code, name,
IIF(ISNULL(leader),
'NO LEADER RECORDED!',
leader)
FROM party</source>
<source lang='sql' class='def e-oracle'>SELECT code, name,
COALESCE(leader, 'NO LEADER RECORDED!')
FROM gisq.party</source>
<source lang='sql' class='def'>SELECT code, name,
COALESCE(leader, 'NO LEADER RECORDED!')
FROM party</source>

<div class="ecomm e-access" style="display: none">Use IIF and ISNULL</div>
<div class="ecomm e-postgres" style="display: none">COALESCE takes any number of arguments, it returns the first which is not null.</div>
</div>
{{Functions ref}}