Hi Jerry, You can split the values using substring and charindex in SQL Server. I guess, you have to write a stored procedure to split them based on delimiter by passing concatinated string and delimiter and get title, first and last names. I can help you in this, if you try out something.. Thanks, Srinivas

Hi Sharma, Could you tell me what are the options, you have and how big is your database? Are you using any tools to migrate the data? Which version of SQL and which version of Oracle? I may help you in this.. Thanks Srinivas

Hi Karthik, Could you more specific on error? what error you are getting? I guess, that will not be a problem,if you are inserting. Srinivas