nulls values

• luissantos

  SSCertifiable

  Points: 7391

  More actions

  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

• David Benoit

  SSC-Dedicated

  Points: 34562

  More actions

  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

• Steve Jones - SSC Editor

  SSC Guru

  Points: 737930

  More actions

  December 4, 2001 at 10:41 am

  #420692

  I'd use ISNULL if you need this.

  Steve Jones

  steve@dkranch.net

• nigelrivett

  SSCertifiable

  Points: 5472

  More actions

  December 6, 2001 at 6:11 am

  #420831

  or coalesce

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