2007/10/27, Drew Jensen <[EMAIL PROTECTED]>: > 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" hey, good idea (as usual) Thanks, Manuel
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
