I'm trying to get a 6.5 database to work properly in sql 2000. There's an SP
which concatenates (sometimes) null values with another string. As SQL 2000
handles this proc differently I've added SET CONCAT_NULL_YIELDS_NULL OFF to
the sp and it works correctly.
An article on MSDN notes that this feature will be removed in future SQL
versions and suggests modifying apps that use this feature. My question is:
What are the alternatives?
[field a] + [field with nulls]
[field a] + coalesce([field with nulls], 'an empty string')
Coalesce returns the first nonnull expression among its arguments.
On May 1, 4:47 pm, "Rod" <email@example.com> wrote: