Forum OpenACS Q&A: Response to String concatenation w/nulls

Collapse
3: Response to String concatenation w/nulls (response to 1)
Posted by David Walker on 07/05/01 07:55 PM
I'll just mention that I have an issue with SQL92 in this matter. It does not make sense to me concatenating something with nothing should yield nothing.

For any concatenation that I'll be doing I need an operator that treats NULLs as empty strings.