Sql string adding problem

Posted by Woland on Stack Overflow See other posts from Stack Overflow or by Woland
Published on 2010-05-12T06:11:34Z Indexed on 2010/05/12 6:14 UTC
Read the original article Hit count: 146

Filed under:
SELECT a.one + ' test ' +b.two from table1 a right join table1 on a.id =b.id 

The problem is that when one is null then it the whole string is null, is there some kind of trick to bypass this problem msSQL 2005

© Stack Overflow or respective owner

Related posts about sql