Hi , I have 2 tables says T1 & T2 and here is the table fld
T1 tin_nbr 9(10). emp_no s9(9) comp T2 acct no 9(10) emp_no X(23) I created a view and in the where clause used the below WHERE SUBSTR ( DIGITS ( t1.emp_no ) , 2 , 9 ) = A.emp_no; This when i tested i am not getting the correct count as expected, please let me know any issue in this comparison? Regards Ron ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
