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

Posted by David Walker on
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.