Post reply

concatenating NULLS in a View

  • July 2, 2003 at 3:20 am

    #160268

    I am using SQL 2K

    I am using a view to concatenate two fields (software and version). If the version field is null I am getting the result as null.

    If I run the query in QueryAnalyser and put SET CONCAT_NULL_YIELDS_NULL OFF

    before it , then it works OK

    How can I achieve the same results using a view.

    SELECT basesoftwarename + N' ' + basesoftwareversion AS Software from tblsware

    tblsware definition

    basesoftwarename nvarchar(40)

    bassoftwareversion nvarchar(12)

    Sample Data

    Access 97

    Norton Antivirus NULL

    DB2 7.0

  • July 2, 2003 at 4:33 am

    #463891

    Try:

    SELECT ISNULL(basesoftwarename,N'') + ISNULL(basesoftwareversion,N'') AS Software from tblsware


    Cheers,
    - Mark

  • July 2, 2003 at 4:59 am

    #463896

    Thanks - that's achieved the perfect result

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply