How to use T-Sql ISNull function in Derived Column Expression?

• guptaopus

  SSCommitted

  Points: 1534

  More actions

  April 24, 2008 at 12:02 am

  #121489

  Hi,

  I have a derived column in which i am concatenating 2 columns but i want to check if any column is NULL then replace it with "" which i am not able to do with ISNULL operator of SSIS.

  Eg code:

  TRIM(SUBSTRING([Column 0],35,3)) + "-" + TRIM(SUBSTRING([Column 0],38,3))

  Please Anybody help me...

• afgone

  SSCommitted

  Points: 1551

  More actions

  April 24, 2008 at 2:36 am

  #806408

  TRIM(SUBSTRING(isnull([Column 0],''),35,3)) + "-" + TRIM(SUBSTRING(isnull([Column 0],''),38,3))