Re: select FORCE_CONCAT(always_there,sometimes_there)?

[Thimble Smith]

On Tue, Apr 06, 1999 at 05:29:42AM -0500, Jay J wrote:
> Am I the only one that would like the _option_ to force CONCAT to return a
> value, even if some of the columns are null?

You can use IFNULL to test:

SELECT CONCAT(always_there, IFNULL(sometimes_there, '', sometimes_there))

Tim