Post reply

To check numeric or not

  • 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)

  • August 18, 2010 at 1:14 am

    #1208328

    sqlusers (8/18/2010)

    ---

    output will be "TRUE" something like that.

    Something like that ... FALSE maybe 🙂

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply