Home Forums SQL Server 2005 T-SQL (SS2K5) Contrary of ISNULL() ? RE: Contrary of ISNULL() ?

  • September 3, 2009 at 5:31 am

    #1048658

    SELECT < Column list >,

    CASE WHEN AuthorDate IS NULL THEN '' ELSE 'Last Upload: ' + CONVERT(VARCHAR(30), AuthorDate, < Appropriate formatting code >) END

    FROM Documents

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass