Post reply

nulls values

  • December 4, 2001 at 10:03 am

    #157534

    i have one table that not allow nulls values in some columns in my account program.

    When i am import txt files some columns have <NULL> values.

    Using DTS or using INSERT INTO in T-SQL expression every time i have errors.

    i am asking if is it possible using T-SQL replacing the <NULL> values in columns with ('')to provide correct values in my table account program.

    Best regards

    my Email adress : luissantos@mobisoft.pt

  • December 4, 2001 at 10:12 am

    #420688

    You can use isnull(ColName, '') BOL covers this with a great deal more detail. Hope this helps.

    David

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

  • December 4, 2001 at 10:41 am

    #420692

    I'd use ISNULL if you need this.

    Steve Jones

    steve@dkranch.net

  • December 6, 2001 at 6:11 am

    #420831

    or coalesce


    Cursors never.
    DTS - only when needed and never to control.

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

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