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
sql
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