Hi

Nice and simple question:

Why won't it work ?

Code:
...
WHERE table.pkid = 1
  AND COALESCE(table.field, '') IN ( '','D' )
I have data, this particular field is null. Without this coalesce line it brings back the rows. With it it brings back nothing.
Is the IN clause filtering the data before the COALESCE is applied?