InstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comWed, 03 Dec 2008 17:32:55 GMT20http://www.teradata.com/teradataforum/Topic11639-1-1.aspxHi Papaya,Looking at your query, i am sure that your column is containing some non integer values thats why it is unable to convert it to decimal and giving u a error.Tue, 14 Oct 2008 13:02:09 GMTmihir_ray07http://www.teradata.com/teradataforum/Topic11639-1-1.aspxHi Vanathi, Can u please provide some more details as its working fine in my systemThanksTue, 14 Oct 2008 13:00:21 GMTmihir_ray07http://www.teradata.com/teradataforum/Topic11639-1-1.aspxHi all,I am getting the same errror. My scenario is i have a field called source_system_code in a table of char '1' and not null. I am trying to insert a value 'V' into that. It is giving be error code 2621 saying bad character format in the field. Kindly help in this.Thanks,VanathiThu, 07 Aug 2008 07:48:17 GMTvanathihttp://www.teradata.com/teradataforum/Topic11639-1-1.aspxIs myvar column of varchar data type?If myvar is varchar data type then you might get this error "bad character in format or data" with error code 2621.This happens because, column being a varchar may contain character values also which cant be converted to decimal/integer by using cast. In this case you have to take care of char values in myvar column.hope this solves your problem.Please let know in case of wrong assumption.Thu, 29 May 2008 02:11:06 GMTdhirajpalsehttp://www.teradata.com/teradataforum/Topic11639-1-1.aspxI am uploading some SAS files into TD, trying to convert string to decimal. I use (case when myvar is null then -999 else cast( myvar as decimal(18,0)) ) as idBut TD gives me an error, saying the column might contains bad character. Why this happened?Wed, 28 May 2008 15:08:43 GMTpapaya