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

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

coalesce( ColumnName, 0 )

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

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

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


"Nathan" <Nathan@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:5BC968CF-3F39-4B95-AD92-F817B5739975@xxxxxxxxxxxxxxxx

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

I wouldlike to return 0 for fields that return null in a left join

Relevant Pages

  • Re: Domain or Workgroup
    ... Arnie Rowland, Ph.D. ... Most good judgment comes from experience. ... to connect to a server and not being properly configured. ... installed, since better security is now available, file storage may be ...
    (microsoft.public.sqlserver.clients)
  • Re: Domain or Workgroup
    ... comments which contradict others' suggestions or material in a ... Arnie Rowland, Ph.D. ... Most good judgment comes from experience. ... to connect to a server and not being properly configured. ...
    (microsoft.public.sqlserver.clients)
  • Re: Domain or Workgroup
    ... Arnie Rowland, Ph.D. ... Most good judgment comes from experience. ... to connect to a server and not being properly configured. ... installed, since better security is now available, file storage may be ...
    (microsoft.public.sqlserver.clients)
  • Re: Domain or Workgroup
    ... Arnie Rowland, Ph.D. ... Most good judgment comes from experience. ... to connect to a server and not being properly configured. ... installed, since better security is now available, file storage may be ...
    (microsoft.public.sqlserver.clients)
  • Re: Linked Server Security question
    ... Arnie Rowland, Ph.D. ... Most good judgment comes from experience. ... that folder and all files in it. ... it's related somehow to the security on that linked server. ...
    (microsoft.public.sqlserver.connect)