Hello All, I have a Address field, I want to bifurcate this filed in two three fields because of length problem. E.g - 1112/3 Raja Ram Apt Udhav Nagar Near Mahadev School Pune 411000 Maharashtra I have two three fields like Address 1,Address 2, Address 3 how should I bifurcate this in these address fields So I use substring but data is not bifurcating as I expected Data is showing like this Address 1 - substring(e.address,1,30) - 1112/3 Raja Ram Apt Udhav Naga Address 2 - substring(e.address,31,30) - r Near Mahadev School Pune 411 Address 3 - substring(e.address,61,30) -000 Maharashtra Address 4 - substring(e.address,91,30) Address 5 - substring(e.address,121,30) Have to show like this Address 1 - substring(e.address,1,30) - 1112/3 Raja Ram Apt Udhav Nagar Address 2 - substring(e.address,31,30) - Near Mahadev School Pune 411000 Address 3 - substring(e.address,61,30) - Maharashtra Address 4 - substring(e.address,91,30) Address 5 - substring(e.address,121,30) Address should be bifurcate selecting 30 character after space Please give me solution on urgent basis Thanks & Regards, -Anagha