SQL Change null values for integer column

• Saran

  Right there with Babe

  Points: 760

  More actions

  November 9, 2022 at 2:44 pm

  #4110539

  Hi All,

  In MSSQL How can I handle null values for integer column. Do I need to update null to zero maybe?

  I am doing BCP out from MSSQL to MYSQL.

  The text file is having null-empty values and MYSQL load is errors out with Incorrect integer value.

• homebrew01

  SSC Guru

  Points: 55549

  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 2 years, 7 months ago by homebrew01.