Re: coalesce a null to a char ?

On 06/04/2009 22:55, Gauthier, Dave wrote:
> How can I do this....
>
> selcet coalesce((select 'y' from foo where name = f.name),'n') from foo f where...
>
> So the query returns a "y" or "n" depending on whether or not the subquery is null.

Are you sure that the subquery is returning any rows? Try something like
this instead (not tested):

  select
    case
      when exists(select 1 from foo where name = f.name) then 'y'
      else 'n'
    end
  from foo....

Ray.

------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------