This topic is locked

use of concat() with replace()

2/8/2008 4:10:49 PM
PHPRunner General questions
V
vytb author

Sorry for the mysql question which can be regarded slightly OT but still...

Does anyone knows how to use concat() with replace() inside?

Ex., concat(replace(column1, 1,'yes'),replace(column2, 1,'no')) with many joins and constrains gives me an empty column. How should I make the columns with the values translated recognizable as columns in order to use these two functions together?
Many thanks in advance!

V
vytb author 2/10/2008

Solved! The stupid 'error' was the presence of null cells in the concat that produce the final null cell/column Just used COALESCE() and everything is in place now!