Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Strange behaviour of concatinated strings with NULL string.
Message
From
26/08/1999 12:51:14
Andrew Macyszyn
The Bms Group Inc.
Chicago, Illinois, United States
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
Strange behaviour of concatinated strings with NULL string.
Miscellaneous
Thread ID:
00258029
Message ID:
00258029
Views:
41
when I run this on sql 7.0:
select '1' + null
I got 1 from one client PC and null from the other.
the server side database option is set to:
SET ANSI_NULLS Off
can someone explain this to me?
thanks.
Next
Reply
Map
View

Click here to load this message in the networking platform