select nvl(mycol,'MYCOL') from mytable; On Thu, Jul 28, 2011 at 10:48 AM, Anthony Ballo <anthony.ballo@xxxxxxxxxxx>wrote: > Is it possible to return the column's name when the contents is NULL? I've > looked at FInd_String but was wondering if someone had a (better) way? > > > Thanks, > > Anthony > > >