Functions commonly used to intercept strings in SQL Server

Functions commonly used to intercept strings in SQL Server: 1. Left (character_expression, integer_expression) function Description: "Left" (' Source string ', ' to intercept leftmost character number '  ) returns the specified number of characters from the start of the string. Sql_server_2008 ', 4); return Result: Sql_2.right (character_expression, integer_expression) function Description: Right (' source string ', ' to intercept the rightmost number of characters ' 
  ) returns the integer_expression character of the specified number of characters from the right in the string (' sql_server_2008 ', 4); return result: 20083.  SUBSTRING (character_expression, start, length) function Description: SUBSTRING (' source string ', ' intercept start position (with character at that position) ', ' intercept length ') return character, binary, text Or part of the image expression Select SUBSTRING (' sql_server_2008 ', 5, 6); return Result: Server

Functions commonly used to intercept strings in SQL Server