Posted by --CELKO-- on 07/31/06 01:19

>> I used SET CONCAT_NULL_YIELDS_NULL OFF do ignore NULL in concatation. <<

Why? Do you always violate ANSI/ISO standards in your code? Why not
write portable code with COALESCE()? Or with a DEFAULT and a CHECK()
constraint?"

Most bad DML comes from bad DDL.

• Next in forum: SQL 2005 Developer edition - install problems
• Prev in forum: Re: Referencing colum names in recordset which is created by join - URGENT!
• Thread view: Re: Sorting with NULL

[Reply to this message]