Task 2: Use REPLACE. Look it up in Books On Line.

Task 1: Find all records that begin with 'THE '. Play with RIGHT() to strip it off.

use update query to remove it from the front of the string and append it to the end.

That should be help enough. There's a difference between helping and doing your job for you. =)