Very Computer

I'm using sp_dboption for changing the concat null yields null to false
beacause i have some concatanation in my application like "abc+var1".  Some
times var1 is null.  The result return null when "concat null yields null"
is true.

When i change this value to false using sp_dboption and i'm using odbc 3.50
the result of the concat. is abc.
With odbc 3.70, the result is null again.

Is there a way to correcte that with odbc 3.70?

thank's,

Joel

ODBC connections set this automatically I think.... Try taking a look
at sp_configure user options or setting the concat option
programmatically after the connection is made.

Quote:> I'm using sp_dboption for changing the concat null yields null to
false
> beacause i have some concatanation in my application

like "abc+var1".  Some

Quote:> times var1 is null.  The result return null when "concat null yields
null"
> is true.

> When i change this value to false using sp_dboption and i'm using
odbc 3.50
> the result of the concat. is abc.
> With odbc 3.70, the result is null again.

> Is there a way to correcte that with odbc 3.70?

> thank's,

> Joel

--
Wayne Snyder MCSE, MCDBA, MCT, SQL SERVER MVP
IKON Education Services, C*te, NC
(Please respond to the newsgroups.)

Sent via Deja.com http://www.veryComputer.com/
Before you buy.

In addition to Wayne's comments:

I believe that Kalen did an article in SQL Mag on this topic. Check out
www.sqlmag.com.

--
Tibor Karaszi, SQL Server MVP
Please reply to the newsgroup only, not by email.

Quote:> I'm using sp_dboption for changing the concat null yields null to false
> beacause i have some concatanation in my application like "abc+var1".  Some
> times var1 is null.  The result return null when "concat null yields null"
> is true.

> When i change this value to false using sp_dboption and i'm using odbc 3.50
> the result of the concat. is abc.
> With odbc 3.70, the result is null again.

> Is there a way to correcte that with odbc 3.70?

> thank's,

> Joel