Re: [dba-users] memo field in query-unexpected behavior

[Drew Jensen]

Manuel NAUDIN wrote:
SELECT
  "id_prod",
  CONCAT( "prod_name", CONCAT(  ' ', "prod_details") )
    AS "product description"
FROM "PRODUCTS"
    
ok, those imbricated CONCAT() are so error prone that I try not to use them ;-)
  

+1

I'll have to double check the parentheses
Thanks
(the other way round was using some CASEWHEN() stuff ..umf)
  

or

SELECT 

   "id_prod", 

   COALESCE(  "prod_name" || ' ' || "prod_details" , "prod_name" ) 

       AS "product description" 

FROM "PRODUCTS"