• John,

    With " order by 2 desc " are you not forcing the query to get result in the way you had desired?

    select NULL,'manoj'

    union select Null,'1'

    union select NULL,'manoj'

    order by 2 desc

    SQL DBA.