CONCAT_NULL_YIELDS_NULL

[gd082]

Hi

I have a problem setting this value. I'd like to concatinate 2 strings, but sometimes one of those 2 is empty. So I tried to set 'CONCAT_NULL_YIELDS_NULL' to False.

USE ADRES EXEC sp_dboption 'adres', 'CONCAT_NULL_YIELDS_NULL', 'False'

I used this function. SQL Server Enterprise Manager says 'Query has executed succesfully', but when I try my statements (so string1 + string2) it's not working!

In SQL Query Analyzer you can set a DB option, but it seems like that's not possible in the Enterprise manager...

 

[bperry]

Rather than adjusting the server settings, you might prefer to handle the condition in the code. That way it will run properly on any server, no matter what the settings (or future settings) are.

Perhaps something like this:

select @String3 = ISNULL(@String1,'') + ISNULL(@String2,'')

(Those are two single quotes, not one double quote.)

bp

 

[tlbroadbent]

Use SET CONCAT_NULL_YIELDS_NULL OFF rather than setting the DB opion with sp_dboption. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.

 

[gd082]

Thanx a lot bp! I've been searching for it for hours!
So I used "SELECT ISNULL(string1,'') + ISNULL(string2,'') as kolom1".

Terry, this SET-option wasn't working either... Thx anyway