To check numeric or not

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

  • 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

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

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

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