Handling with null values

• cutespn

  SSCommitted

  Points: 1669

  More actions

  March 26, 2003 at 5:43 am

  #106373

  Hi,

  I have a column caled pgm_id(datatype is int) in source table and same data type in destination table.

  But problem is the column pgm_id in source table allow nulls whereas the destination table doesnt allow null.

  So how to handle it.

  Thnks in advance

  
  
  
  
  
  

  Regards,
  Sudheer 
  

  
  

  

• Jeremy Kemp

  SSCertifiable

  Points: 6754

  More actions

  March 26, 2003 at 6:25 am

  #452174

  Two ideas.

  1. Change the destination table to accept nulls.

  2. Use isnull to replace the nulls with another value:

  select isnull(column_name,replacement_value)

  from tablename

  Jeremy