1.LEFT (character_expression, integer_expression) function Description: Left (' source string ', ' the number of characters to intercept leftmost ') returns the specified number of characters from the start of the string. Ql_server_2008 ', 4); return Result: Sql_
2.RIGHT (character_expression, integer_expression) function Description: Right (' source string ', ' to intercept rightmost number of characters ') returns the integer_expre of the specified number in the string starting from the left Ssion character Select right (' sql_server_2008 ', 4); Results returned: 2008
3.SUBSTRING (character_expression, start, length) function Description: SUBSTRING (' source string ', ' intercept start position (with character at that position ') ', ' intercept length ') returns the character, binary, Text or part of an image expression Select SUBSTRING (' sql_server_2008 ', 5, 6); return Result: Server
Functions commonly used to intercept strings in SQL Server