functions commonly used to intercept strings in SQL Server:1. Left (character_expression, integer_expression) function Description: Left ('Source String','to intercept the leftmost number of characters') returns the specified number of characters from the left of the stringSelectLeft ('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 from the right in the stringSelectRight ('sql_server_2008',4 ); return Result: - 3. SUBSTRING (character_expression, start, length) function Description: SUBSTRING ('Source String','intercept start position (with characters at that location)','Intercept Length'returns part of a character, binary, text, or image expressionSelectSUBSTRING ('sql_server_2008',5,6); Return Result: Server
Common functions for intercepting strings in SQL Server