Post reply

Varchar to Int Using active X

  • May 10, 2006 at 6:59 am

    #68517

    i have a text file that i need to insert into a table . one of the columns comes over as a varchar, but it needs to go into an int column. i have tried everything i know to do this, but i keep getting an error. does any one have any tricks or work around for this.. and dont say cast or convert cos i have tried it and it does not work.

    thanks

    [font="Comic Sans MS"][/font]It is what it is.

  • May 10, 2006 at 8:18 am

    #637007

    What is the error?

    perhaps the field that is supposed to be int, contains blanks, or alpha characters.

  • May 10, 2006 at 8:34 am

    #637012

    indeed most of the fields contain null value.. i did not think about that.. any ideas of how to program around this?

    [font="Comic Sans MS"][/font]It is what it is.

  • May 10, 2006 at 9:08 am

    #637025

    Take a look at the COALESCE and ISNULL functions

  • May 11, 2006 at 7:32 am

    #637237

    will do thanks

    [font="Comic Sans MS"][/font]It is what it is.

Viewing 5 posts - 1 through 4 (of 4 total)

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