Help Converting Case Statement to SSIS Expression

• mbrady5

  SSCrazy

  Points: 2835

  More actions

  May 18, 2015 at 9:14 am

  #318232

  Hello,

  I need some help turning this into an Expression in SSIS. Appreciate any help. Thanks

  CASE WHEN ISNUMERIC (Left (DESIGN_NO,1)) = 0 THEN DESIGN_NO

  WHEN ISNUMERIC (Left (DESIGN_NO,5)) = 1 THEN Left (DESIGN_NO,5)

  ELSE Left (DESIGN_NO,4) End AS Final_Die

• John Mitchell-245523

  SSC Guru

  Points: 148809

  More actions

  May 18, 2015 at 9:53 am

  #1798684

  Something like this:

  ISNUMERIC (Left (DESIGN_NO,1)) = 0 ? DESIGN_NO : ( ISNUMERIC (Left (DESIGN_NO,5)) = 1 ? Left (DESIGN_NO,5) : Left (DESIGN_NO,4) )

  The syntax may not be 100% correct, but there should be enough there to get you started.

  John