LEFT

LEFT function

String functions in MS SQL SERVER

String functions in MS SQL SERVER

Transact-SQL string and datetime functions

RIGHT function

String functions in MS SQL SERVER

LEN function

String functions in MS SQL SERVER