List:General Discussion« Previous MessageNext Message »
From:Thimble Smith Date:April 6 1999 6:08pm
Subject:Re: select FORCE_CONCAT(always_there,sometimes_there)?
View as plain text  
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))

select FORCE_CONCAT(always_there,sometimes_there)?Jay J6 Apr
  • Re: select FORCE_CONCAT(always_there,sometimes_there)?Thimble Smith6 Apr