SQL Code Like "MID" in VB

i need a code on SQL that like to "mid" or "left" on VB

[abulhallaj]

I need a SQL Code that return some characters of an field on my ASP pages.

for example we have this code on VB:

Mid("ABCDEFG",1,3) ; it's return : ABC

i need a code like this on SQL

[IanTurner]

RIGHT ( character_expression , integer_expression )

LEFT ( character_expression , integer_expression )

SUBSTRING ( expression , start , length )

PATINDEX ( '%pattern%' , expression )

REPLACE ( 'string_expression1' , 'string_expression2' , 'string_expression3' )

All available in SQL

[abulhallaj]

thanks a lot. :) .)