Forum OpenACS Q&A: Response to NULL SQL issues

Collapse
2: Response to NULL SQL issues (response to 1)
Posted by David Walker on 01/24/02 11:53 PM
The concatenation operator || returns NULL if one of the items being
concatenated is NULL.  Your best bet is probably to make the admin_note
field default '' and update all the currently NULL fields to equal ''