sql server mseq: Set default for null values in unmatched rows of left join -- sql server mseq

Set default for null values in unmatched rows of left join

Nathan
11/7/2006 11:28:01 AM

sql server mseq:
Is there an easy way to set a default value for values in unmatched rows
that return null

Re: Set default for null values in unmatched rows of left join

Arnie Rowland
11/7/2006 10:34:53 PM

In the SELECT statement, use COALESCE() for the column that returns =
NULL.

coalesce( ColumnName, 0 )

--=20
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.=20
Most experience comes from bad judgment.=20
- Anonymous

You can't help someone get up a hill without getting a little closer to =
the top yourself.
- H. Norman Schwarzkopf

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server mseq group.