SQL Change null values for integer column

• homebrew01

  SSC Guru

  Points: 55566

  More actions

  November 9, 2022 at 4:36 pm

  #4110590

  You could add a step to update your file before the BCP.

  or

  In your select, you could use a CASE statement to replace NULL with 0

  SELECT 
  CASE WHEN FIELD1 is NULL then 0 ELSE FIELD1 END
  , FIELD2, FIELD3
  from MYFILE

  • This reply was modified 3 years ago by homebrew01.