• still now i thought COALESCE will return the datatype of Non NUll value. Today only i learnt it will consider the highest percedence..

    Thanks to author for posting nice qstn..

    --
    Dineshbabu
    Desire to learn new things..