nulls values

  • 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 :

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




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

  • I'd use ISNULL if you need this.

    Steve Jones

  • 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