DIGITS gives you a character string representation of a number so you are getting an implicit conversion from chars to number on the DIGITS ( t1.emp_no ) , 2 , 9 ) = A.emp_no;
Go to the DB2 listserv or the SQL manual on automatic conversion rules. Mike On Mon, Mar 26, 2012 at 9:35 AM, Ron Thomas <[email protected]> wrote: ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
