Hi, I need to get last 50 characters at a chunk of 25 characters each in to two columns If the notes column has less than 50 characters for ex :43 Then I need to get Last 25 in to one column and remaining (18 chars) into second column. I tried using substr and length functions first column is fine but second column has an issue: select substr('ABCDEF GHIJ',length('ABCDEF GHIJ')-25,25) from dual; Thanks, Kiran