LEFT/RIGHT Reverse operator

Returns the left part of a character string with the specified number of characters.

Returns the left part of a character string with the specified number of characters.

Is an expression of character or binary data. character_expression can be a constant, variable, or column. character_expression can be of any data type, except text or ntext, that can be implicitly converted to varchar or nvarchar. Otherwise, use the CAST function to explicitly convert character_expression.

SELECT 
    [game_name], LEFT([game_name], 5)
FROM 
    [dbo].[console_games]

More infor here

SELECT [game_name], RIGHT([game_name], 5)
from [dbo].[console_games]

More info here

SELECT [game_name], REVERSE([game_name])
from [dbo].[console_games]

More info here