Hi, I'm tring to substring a character field (eg. 00000000012345678912) in proc sql and and need to convert it to numeric.  I only need the 1234567891 from the field (position 10 for 11 fields).  I'm using this format : cast((substr( AR_NO,10,11)) as integer) as AR_NO_SUB , but getting an error (below) ERROR: Teradata row not delivered (trget): Overflow occurred computing an expression involving DB.AR_NO. if I do cast((substr( AR_NO,4,11)) as integer) as AR_NO_SUB i get 69267, but if I do cast((substr( AR_NO,5,11)) as integer) as AR_NO_CUB I get the error as above in red. Thankss for your help. ... View more

Is there a reason why this is not getting me any data ?.. Select  a.* from Mainframe.data where APP_ID = ('%61738495%') This is just a test on one account, but I need to do it for 1000's of accounts and in the above case the actual APP_ID is 6005617384952 , I have a file with the acct number stripped in the middle (as shown above), and need to make sure I capture it as it is embedded in the mainframe data.  When I run the above query I get no results.  If I put where APP_ID = ('%6005617384952%'), I get the result, but that doesn't help, since I don't know the full acct number for all 1000's accts.  Isn't the meaning of the % to capture any possible value in it's place, if you don't know it?  Thanks ... View more