To check numeric or not

• sqlusers

  SSCrazy

  Points: 2463

  More actions

  August 18, 2010 at 12:38 am

  #142362

  Hi,

  Is there any way to check my varciable value has numeric value or not in SSIS 2005 using derived column?

  Ex, v_Var = '123A'

  ISNUMERIC(v_Var)

• Phil Parkin

  SSC Guru

  Points: 247180

  More actions

  August 18, 2010 at 1:14 am

  #1208328

  sqlusers (8/18/2010)

  ---

  ---

  output will be "TRUE" something like that.

  Something like that ... FALSE maybe 🙂

  ---