<div>
select CONCAT(COALESCE(field1,'')<wbr />, COALESCE(field2,''))
</div>


select CONCAT(COALESCE(field1,''), COALESCE(field2,''))

<div>
In sql server<br />
<br />
SELECT ISNULL(field1,'')+ISNULL(f<wbr />ield2,'')
</div>


In sql server

SELECT ISNULL(field1,'')+ISNULL(field2,'')

<div>
In Oracle -<br />
select concat(nvl(field1,''),nvl(<wbr />field2,'')<wbr />)<br />

</div>


In Oracle -
select concat(nvl(field1,''),nvl(field2,''))


<div>
in ingres<br />
select concat(ifnull(field1,''),i<wbr />fnull(fiel<wbr />d2,'')) from table<br />
<br />
in firebird<br />
select coalesce(field1,'') || coalesce(field2,'') from rdb$database<br />
<br />

</div>


in ingres
select concat(ifnull(field1,''),ifnull(field2,'')) from table

in firebird
select coalesce(field1,'') || coalesce(field2,'') from rdb$database



<div>
my initial suggestion works in mysql
</div>


<div>
but mysql doesn't have COALESCE ?
</div>


<div>
<div class="content wysiwyg-content">
I would like to concat two fields <br />
<br />
select CONCAT(field1, field2)<br />
<br />
if field1 or field2 is NULL then i want it treated as a blank string. I've tried CAST, but it doesn't work. As soon as you have a null in a CONCAT it will not work at all, not even partial.<br />
<br />
Thanks
</div>
</div>


I would like to concat two fields 

select CONCAT(field1, field2)

if field1 or field2 is NULL then i want it treated as a blank string. I've tried CAST, but it doesn't work. As soon as you have a null in a CONCAT it will not work at all, not even partial.

Thanks

CONCAT a fields if one field is NULL

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.