REPLACE(old,start,num,new)
Returns @old with @new replacing @num characters from @start.
MID , SEARCH , SUBSTITUTE , TRIM