Hi. I have name field as person_name in my database as one field. I want to produce a report in the formate of first_name,last_name and middle_name. How can splet the one name field into three. For example i have the data as Haja Moinudeen Mohammed what i need is First_name :Haja Middle_name :Moinudeen Last_name :Mohammed If i use left of and right of functions it will fetch fixed no of characters it may leads to wrong result. Plz help me for my solution. Thanks..