In VB you can get characters form a specified place form a string with mid function. Is there a similar function in SQL?

thanks

Jamppa