Substring. Seriously, it replaced Right, Left, and Mid. I'm not quite sure what you are seeing that you can't replicate with it.