May 10, 2006 at 6:59 am
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
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
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
Take a look at the COALESCE and ISNULL functions
May 11, 2006 at 7:32 am
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