View Single Post
Old April 7th, 2006, 03:19 PM
robprell robprell is offline
Friend of Wrox
Join Date: Aug 2004
Location: Orange County, CA, USA.
Posts: 385
Thanks: 0
Thanked 0 Times in 0 Posts

you may want to look into set concat null.

In version 7 a null added to a string yeilds a string. In sql 2000 the default setting (changable) for the server is to return a null. You can set the setconcatnull in your query to get consistent results. Or your can check to see if your using different versions of SQL or the setting for default on concatnulls is the same on both servers.