Re: VARCHAR changes to INT - UNION

2005-07-15 Thread Michael Stassen
Eugene Kosov wrote: Dennis Duggen wrote: Hi list Im new to the list so i hope it's the right place for my post. For a projekt i am combining different tables. Everything seems to work, but in some rows the "Kode" field VARCHAR(10) ends up as INT. I will try to explain with an example. Table1

Re: VARCHAR changes to INT - UNION

2005-07-15 Thread Eugene Kosov
Dennis Duggen wrote: Hi list Im new to the list so i hope it's the right place for my post. For a projekt i am combining different tables. Everything seems to work, but in some rows the "Kode" field VARCHAR(10) ends up as INT. I will try to explain with an example. Table1 46 47 48 67 Table2 B

VARCHAR changes to INT - UNION

2005-07-15 Thread Dennis Duggen
Hi list Im new to the list so i hope it's the right place for my post. For a projekt i am combining different tables. Everything seems to work, but in some rows the "Kode" field VARCHAR(10) ends up as INT. I will try to explain with an example. Table1 46 47 48 67 Table2 BBEGYNDER BVILDIVAND 01E