SQL Server intercepts strings

2. Functions commonly used to intercept strings in SQL Server:
6. 1. Left(character_expression, integer_expression)
8. Function Description:Left ( ' source string ', ' to intercept the leftmost number of characters ')
10. Returns the specified number of characters starting from the left of the string
12. Select Left (' sql_server_2008 ', 4);
14. return Result: Sql_
20. 2. Right(character_expression, integer_expression)
22. Function Description:Right ( ' source string ', ' to intercept the rightmost number of characters ')
24. Returns the integer_expression character of the specified number from the right in the string
26. Select Right (' sql_server_2008 ', 4);
28. Results returned: 2008
34. 3.SUBSTRING (character_expression, start, length)
36. Function Description:SUBSTRING ( ' source string ', ' intercept start position (with character at that position ') ', ' intercept length ')
38. Returnspart of a character, binary, text, or image expression
40. Select SUBSTRING (' sql_server_2008 ', 5, 6);
42. return Result: Server

SQL Server intercepts strings (GO)