Hi,
meinst du so?
update dbo.contactemail1table set emaildisplayas=isNull((select lastname from dbo.contactnamestable where dbo.contactemail1table.contactserviceid=dbo.contactnamestable.contactserviceid) , ") + ', ' + isNull((select firstname from dbo.contactnamestable where dbo.contactemail1table.contactserviceid=dbo.contactnamestable.contactserviceid) , ") + ' (' + isNull(emailaddress, ") + ')' where contactserviceid=7;
:confused:
Ich will doch im Grunde nur, dass er die Werte die er hat hinschreibt, auch wenn eine Variable ggf leer ist.
Sprich
lastname firstname E-Mail
Mustermann Max max.mustermann@mustermann.de
Musterfrau frau.musterfrau@musterfrau.de
EMailDisplayAS
Mustermann, Max (max.mustermann@mustermann.de)
Musterfrau, (frau.musterfrau@musterfrau.de)