hai all,

       in a database i have an view which contains 'Name' as the combination of firstname,lastname and suffix separated by comma ',' the problem occurs when i run the scripts on my client server it gives comma ',' for null values.where the same scripts gives the null values for the remote server

__________________
Regards,
P.Madhusudhana Rao

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.

SELECT ISNULL(LastName, '') + ', ' + ISNULL(FirstName, '')
FROM Employees