Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-04-23 : 09:02:29
|
| Ian writes "I have written views in SQL Server 7.0 that concatenate fields. The problem is that even after running the Set CONCAT_NULL_YIELDS_NULL OFF statement, I still get the NULL result if one of the fields are NULL. Is there something that I am missing?Thank you very much." |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2002-04-23 : 09:16:13
|
| Look up SET Options in Books on Line and read the section about "Duration of SET Options".If you can't figure out your error from that, take a look at using coalesce or isnull in you view.<O> |
 |
|
|
Nazim
A custom title
1408 Posts |
Posted - 2002-04-23 : 09:29:02
|
| Alternatively you can use isnull function too .set nocount ondeclare @a varchar(30)select @a+'good' -- Result : NULLselect isnull(@a,'')+'good' --good--------------------------------------------------------------Edited by - Nazim on 04/23/2002 09:30:07 |
|
|
|
barret
Starting Member
1 Post |
Posted - 2008-09-09 : 14:48:16
|
| here's the low down for all the people, like me today who took to much time on this.........in microsoft sql server management studio.........Tools->Options->(see print out): Uncheck the box Set Concat_Null_Yields_Null |
|
|
|
|
|
|
Set CONCAT_NULL_YIELDS_NULL OFF Not working