If I have a column in my employee table called 'NAME' and it contains text like 'Mr. John Smith Jr.' , how can I search my table to find rows like this, strip out the 'Mr.' and put it in a new column called PREFIX and strip out the 'Jr.' and put it in a new column called SUFFIX? I am in a SQL Server environment. Is there a way to actually take the Data from the one field and move it to another, or can I just find the 'Mr.' And 'Jr.' and identify them in the results?