|
|
Archives of the TeradataForum
Message Posted: Thu, 03 Nov 2005 @ 15:13:39 GMT
Subj: | | Re: 3535: A character string failed conversion to a numeric value. |
|
From: | | Rice, Roberta R |
David Micheletto wrote:
| Is the SELECT doing anything that could cause an implicit data type conversion? (i.e. to a character field having a non-numeric) | |
I don't think this was my problem as I got the same error no matter what field I tried to populate in my temp from my perm. Also, when I
created the temp I did a cut and paste to make sure I didn't fat-finger. In addition, I verified that I had the temp table fields correctly
defined after the first error. The puzzling thing is that when I did a select* as opposed to naming the field I wanted populated from the perm
table, it worked just fine.
Roberta "Bert" Rice
RSS Common Key
Technology Services - Topeka
| |